Why hear in absolutes? I said essentially what you did: "Different projects may have different requirements"
You find ORMs useful, I do not, they aren't mutually exclusive.
Also, An ORM is inappropriate for certain forms of inter-team collaboration. Data scientists often prepare SQL that we need to integrate into our services. Asking all at a company to learn a language specific ORM isn't practical. SQL is, for better and worse, an important common tool.
Nobody is saying only use an ORM, but the anti-ORM crowd seem to think that there’s only one true way to do things.
I don’t know why so many programmers think purely in binary “good or bad”. Different projects may have different requirements.