I always thought "Water, water, everywhere, / Nor any drop to drink" didn't refer to alcohol at all, but was simply pointing out that sailors can ironically die

I always thought "Water, water, everywhere, / Nor any drop to drink" didn't refer to alcohol at all, but was simply pointing out that sailors can ironically die of thirst on a ship literally surrounded by water, because salt water isn't drinkable.