That cholera outbreak was notable because most of the city had clean drinking water. Which means their mitigation strategies largely worked even as they didn’t understand the root causes of cholera.

Also, Roman aqueduct water had minimal lead contamination due to the high flow rate, unfortunately they used lead for a huge range of different things like cups which got lead onto people’s mouth and hands while eating etc.