ICEBERG_VACUUM_MORE_RUNS_NEEDED

VACCUUM deletes orphan files and expired snapshots, but it won't delete snapshots otherwise (you would lose history).
You can expire snapshosts by configuring in the table when that should happen or by expiring them manually:
https://iceberg.apache.org/docs/latest/spark-procedures/#expire_snapshots

Hello,

The error is expected as it is the behaviour of the command by design. There is a limitation on number of files set as of now to avoid query timeout while the command performs deletion of files in a single run. It is suggested to run the command multiple times until all the files are removed.