The premise is, the general population is too stupid to do the right thing themselves and need to be reminded of the drought by being inconvenienced by completely ineffective performative policies.
All this actually does in practice is diminish trust in authorities to make good decisions. If the drought policies are bogus, which other ones are too? Fuel economy standards? Air quality? OSHA?
Instead of this nonsense - just allow the market to set the price of water based on what’s available.
Of course, the answer there is usually “Oh but there are special interests that need to be able to consume as much water as they want without paying more for it, even in a drought!” And thus as usual the problem is not the personal conduct of individual citizens but corrupt and spineless politicians who are not actually interested in solving any problems.