The one time I remember that drunkenness mattered in 5e was when a PC was deliberately trying to get some troublesome NPCs drunk. We resolved it by having the drinkers roll CON saves vs Poison. One failed save and you get the Poisoned condition, two failures and you fall asleep.
(The PC won, he...