Different people different story my friend, there are people who can't erect while drunk, and some people, weirdly getting more horny, some people have the experience called "Whiskey Dick", where a men's penile system doesn't perform at all when he's drunk. But, some people lose all inhibitions and all horny thought are often ended up mostly in a sex situation or sometimes masturbation. Let just say, this man is the latter one. But yeah i agree, when someone is really drunk, or sometimes wasted, the penis just don't work. But when drunk (not wasted), often times dirty thought becomes uninhibited.
And good on you to quit drinking.