The problem is that there are different kinds of ORMS.
One where the model is created and either the tables are generated from the model or some mapping exists. The other kind takes the database as a source of truth and from sql queries generates type safe wrappers and models.
I believe most people only have experience with the first kind which has some problems but never really experienced the second kind which is very near to the database.