The classic example is accidentally committing a binary file or some other large-as-in-filesize garbage -- simply deleting the file preserves it in history, bloating the size of the repo.
Somebody accidentally checks in an AWS private key and it gets found out much later.
Then removing it from history doesn’t do anything because you already need to rotate the key
It ends up being a worthwhile thing to do if someone has checked in a large file that shouldn't be in git or whatever