I always understood the myth as: "When you traveled somewhere and didn't know about the water-quality, you drank beer instead".

Not that beer is immune against making you ill, but chances are random beer in some random village is better than random water in some random village, since the village people would use the good water for the beer.