Yes, the Navy had a culture of ignoring rules regarding alcohol consumption.
But, well, I really do think that everyone here should be very cognizant of the fact that changing culture is at best, a very difficult task, one which requires buy in from all levels. Lord knows that we've seen this is the case in basically every other aspect of the CAF's culture change initiatives, why should alcohol consumption in the RCN be any different?
The culture of "drinking to excess at sea is ok" isn't really something that could be easily remedied with small corrections or simply enforcing existing rules because the very people who would need to be enforcing it are the same ones who were consistently breaking it. And I think you're really downplaying the addictions aspect here. If you allow an alcoholic two drinks, are they doing to be satisfied and want to stop at that? No, they're going to use every trick in their book to keep at it.