I don't drink, but I realize that getting home after one has been drinking is a legitimate problem that does encourage people to drive drunk.
It's one thing that I hope that self-driving cars will help address in the long run. If everyone's got their own electronic chauffeur readily available, it's lot easier to let them get one home safely.
I've been saying my next car will have FSD for... almost a decade now. I have lost hope that what you describe will be a reality for me anytime soon, and with the progress of self-driving in general? Very. Little. Hope.