Water was a somewhat precious resource for most folks. You either fetched it from the well or from the source plus have a fire to heat the water over - a fire that you aren't going to need for that day's food. Not to mention that you might need to do this for your family of 6 and doing the rest of your chores - all of which took much more work than today.
the beer or wine would have likely been delivered by horse and wagon if one purchased it. Otherwise, it likely would have been produced and stored on-site - the fetching would have been a bit different.
Again, this is not true. Water only became a scarce resource for some when population density reached a certain point.
https://www.reddit.com/r/AskHistorians/comments/1yts0v/comme...
Edit: never thought I'd be quoting the bible here as evidence of something
The short life expectancy is due to a high risk of death as a baby or child.
All we have to do is boil it, because we have a germ theory. If i'd been drinking from the same well for 30 years, I don't think I'd make the connection that the water was somehow bad unless it tasted funny or was cloudy.
However, if i acquire a taste for tea, a good fraction of my water is automatically purified.
Alcohol, of course, is a nice way to store those hard grown calories. Grapes don't last long, wheat gets infested with bugs and rats. Beer and wine keep for a while. And of course, also purified.
Archaic doesn't mean stupid. We are all lucky John Snow was so diligent. That was a tough connection to make. And of course, once it was discovered, people regularly boil water when there are issues with the local water supply.
We got kind of lucky by getting addicted to things that inadvertently had unknown positive effects. Which, in my humble, non immunologist or doctor kind of way, probably outweighed the really terrible negative effects of long term massive alcohol consumption.