There's more than a hint of schadenfreude about some of the comments in this thread.
Nevertheless, the hard word probably does need to go out about drinking to excess. Like many on here, I've seen some pretty poor examples set by senior officers when on deployed operations. Gulf War 1, in 'dry' Saudi Arabia, being a case in particular.
There was also an incident in Bahrain, when a crew was breathalysed by the military police when driving in to fly a mission during Op Southern Watch. The driver failed, so had to leave the car at the gate. Then they went flying......
Most of us like the odd sherbet, but FFS, there are times and places.
As for blanket bans being imposed on the otherwise innocent, who are capable of self-discipline, that's totally out of order.