Yes, of course once the company reaches a certain scale you need specialized roles and/or software that you use, that makes sense.

But is "companies of scale" what "modern devs" refer to? What is a "serious" company?

There is a lots of parameters that goes into the choice of self-hosted DB / managed DB, not just if the devs are "modern", or the company is "serious".