No, companies don't use CosmosDB because it's NoSQL and plenty of Devs can and will screw that up. Not great when you are paying per transaction.

However, I know many which have switched MSSQL to Postgres/MySQL happily. Azure supports those well.

Azure using SRE here.