Arcologies may very well be the future. Owning a HEPA air filter and reverse osmosis water filter slowly becomes the norm in my circles.
Sounds like a massive waste and headache for basically no benefit.
I have no idea how real the risk is, and it all seems less risky than drinking unfiltered water in most areas.
But it's no headache for me to mix RO water with bottled spring water, since I prefer the flavor and it takes seconds.
It’s mostly down to infrastructure, the pipes, not the quality of water released.