“Alcohol was a safer choice than most water in those days.”
Bingo!
That’s why sailors drank grog. (alcohol mixed with water) Water in a barrel would be pretty nasty if not downright deadly after a month or so and the alcohol kept the bacteria at bay.
I’m guessing that rural people probably drank more water than urban people simply because it was easier to find safe sources.