Is that really true these days? Setting up Postgres read replicas with automatic fail over across multiple machines is pretty trivial in the cloud with services like RDS, spanner etc. And although doing it in your own datacenter is still a big job it's far from impossible.

Huh? Replicas are easy, and hot standby nodes aren’t that hard either. There are also various active-active solutions if you need that.