Doesn't even have to get very intense. A simple timeseries schema gets slow/annoying quickly with an ORM.
I think for a lot of things an ORM is “good” at, you could likely just have a bunch of static JSON files and retrieve them from disk with zero practical difference.
I just can’t wrap my head around why you even *need* a database in those cases.
You need a DB if you need to insert/update those objects transactionally, plus it's more convenient than mapping DB entries to files on disk. But you don't need an ORM for that anymore because Postgres and MySQL have json/jsonb types.
Some of us do very intense compute in very large datasets, and ORM are not capable in those tasks. At all.