Medieval folk didn't drink alcohol to avoid dirty water

Except that in medieval times most people lived in the countryside, so most people weren’t exposed to the unsafe water conditions in urban areas. Don’t the cholera epidemics in London suggest that people were consuming water, because they mistakenly thought it was safe?