I've flown hundreds of times and I've never seen anyone behave inappropriately because they were drunk on a flight. I know it does happen, but it's rare. Not a reason to ban alcohol on a flight.

Anyway, the flight attendants never give you enough on a flight to get drunk, so if someone's drunk they got drunk before the flight.