Alcohol normally does not affect other passengers either medically or otherwise
Don't know about you, but getting knocked out or requiring psychological help would certainly qualify as having been affected in my book, medically and otherwise.
The airlines, at least as a group, will not ban alcoholic beverages. It simply won't happen.
The airlines, as a group, will do whatever their regulator tells them to do. Just like some airlines were never going to voluntarily ban smoking, but regulations eventually made them.