My wife was a finance director at a municipal water utility in an old city. Water supply infrastructure wasn't a ticking timebomb -- many pipes last literally centuries, and utilities can proactively use sensors and robots to find weak pipes to repair without digging up half the city. They had a capital program that worked, lines were replaced based on risk and there was a reserve for breaks or other failures.
The higher risk area from a cost point of view is sewers. They don't age as well and as we pave move stuff, many older sewers and combined storm/sanitary systems are unsafe and vulnerable.
The Flint issue isn't about old pipes. It's about incompetent engineers who should be criminally charged for incompetence.