Airports & aircraft should be total alcohol free zones. Problem solved
Why stop at airports and aircraft?
Totally ban alcohol in the UK and you would stop all the drunk drivers, all the alcohol related injuries and deaths and the crime statistics would fall dramatically.
Or there is another option.
Simply use the existing laws and regulations already in place and refuse boarding to anyone who is or appears to be drunk, or if someone is found to be drunk when on board, prosecute them at a later date.
I fly a great deal, and when doing so I enjoy the odd beer or glass (or two) of wine. Why should I be forced to give this up simply because of a tiny percentage of pax who don't know when to stop.