This is such an interesting remake, I remember playing this when it came out more than 10 years ago, I didn't think it was anything special then.
From what I can see it sold more than 1 million copies back then though, interested to see how well the remake is received and how popular it is.
I'm in the same boat. The water based upkeep mechanic seems punishing, especially for time starved / more casual gamers.
I do think it's very on theme with the game, I hope that they'll tweak it over time - something interesting could be adding a way for more active players to contribute surplus water to a shared supply.
If they manage to tidy the game up and fix some of the glaring issues I'd likely still give it a try even with the water "feature".
Does the mechanic turn you off the game completely?