From messes in share refrigerators, microwaves, or counter space, to restrooms issues that make you wonder how often the maintenance people service it each day and when. I am not sure if this is just a US thing but I used to expect better from coworkers.
Even casual house parties attract integrity-less people who will destroy your carpet by bringing food into carpeted rooms and then trampling it over without seemingly noticing. That's why it's good for every human on the planet to have experience with cleaning various things, so they know how much work it is when they make a mess.
https://www.youtube.com/watch?v=9hxVWjW4TuM
I would be happy if municipalities simply cleaned and maintained public spaces like subways. It's possible, but it's a boiling the ocean problem. Homelessness, mental illness, vicious youth, all in a context of ever-decreasing public infrastructure investment and bitter inequality of resources and opportunity-- it doesn't help make for a clean subway system.
Nobody has the 'right' to be a slobbering mess-making drunk in public. At all.
Ignoring that trying to convince the entirety of society to never drink again at social gatherings (even in your "drunk at home" ideal unless people exclusively drink alone and never at other people's homes they will still need a way to get home) is a complete non-starter based on the last 9,000-odd years of human society and interaction.
Ignoring that removing all public consumption of alcohol from bars, restaurants, sports events, and basically everywhere else would have a huge knock-on effects for all sorts of areas of the economy.
Ignoring that many people are able to drink the 2-3 beer that makes it illegal for them to drive without becoming a "slobbering mess-making drunk".
Ignoring all the thousand other anti-social things people do on transit and in public that makes life miserable most places.
Your idea makes sense and will solve your annoyance without thousands of people dying every year.
It's disingenuous to attack me - after all the 'public drunkenness' violation was voted into law, and not just by me personally.