Aside from the 9000lb gorilla of ag/industrial versus urban/ suburban water use, I think that its clear that tiered rate based structures are a clear failure. We knew this half a decade ago, but its become impeccably clear with articles like these.
Its very very easy to see blame the millionaire/ elite class in this situation, but its important to acknowledge that the fact that these homes use 20-40% of a water districts total use has been well known for years. Likewise, water districts are not incentivised to decrease this class of water users overall use because that 20-40% of water use might represent 60%+ of a water districts total income. This is due to tiered rates. The reality is that famous person XYZ never ever sees the water bill and they just don't care. This is something one of their assistants or manager deals with, and relative to their income, even if their water bill is 50k a month, it just doesn't matter.
So to be clear, districts, through tiered rates, have been incentivised to not act on who they already know are their most wasteful customers. Those most wasteful customers do not care how they spend on water a month.