Snapshot sets `OVERWRITE` while `DELETE` is expected

### Feature Request / Improvement

Also the summary is off, there is just one 1 row deleted and nothing has been added.

![image](https://github.com/apache/iceberg/assets/1134248/d4e523dc-cbd5-4cf5-b4c1-c07672f8969a)


### Query engine

None