I can see both sides, and in no way do I think the OP or even CFH are in any way irresponsible, but in the end, I’d ban alcohol consumption on all public transport. There’s just no need for it. Whilst it’s perfectly possible to have a responsible tipple, a significant minority of travellers people simply aren’t responsible, and spoil it for everyone else. Fellow travellers and staff should not have to deal with intoxicated idiots, and there’s simply no compelling reason why anyone should have the ‘right’ to consume a behaviour affecting substance before being locked into a confined space with a hundred or so other humans for several hours.
It’s a bit like speed limits; responsible drivers wouldn’t need them. You’ve got to make rules to control the lowest common denominator, sadly.