What I mostly miss is a good tool focused on writing SQL like Management Studio from MS SQL Server. Something that allows me to easily open complex large scripts in a full editor, execute parts or all of it easily and get results back. Not much gui, not many wizards, but a good experience. Most tools I find for pg are either full console or full guis with too much focus on wizards. It's like the people using it are uncomfortable with SQL for some reason.
But having followed pg for 15 years or so, I don't think they want or need to be the most popular database. They just want to be a damn good database server, and they are.
Note that I'm not from the US, I'm from Brazil. Here windows pretty much dominates the landscape.
But this is also important: while the US is currently quite apple-centric, most countries are not. And although the US concentrates a lot of tech companies, it's still only 4% of the world.
So even corporate world is changing.
I'm not stating that these stats are the ultimate sources of truth. But those are good references. If you were to measure the reality in most countries, I doubt those numbers would swap places.
In Brazil I see lots of devs using Macs too. It's just not the majority of them.