well hang on, you don't have to outright AVOID drinking, you just need to be responsible with your drinking and limit it so it doesn't control you.
also this passage pretty clearly describes KINGS and RULERS, not just the average person. while it can be interpreted that way, the reasoning as to WHY a king shouldn't drink only applies to those in power
Proverbs 31:4-5 ESV: "It is not for kings, O Lemuel, it is not for kings to drink, or for rulers to take strong drink, lest they drink and forget what has been decreed and pervert the rights of all the afflicted."
overall, i think this verse is just to say "don't be an alcoholic" since you don't instantly become a despicable person from taking a shot of wine. it CAN lead down that path, but it's not a guarantee and by keeping yourself in check you can avoid that path entirely
a lot more people do than you think. venting is good but a lot of people will just say something like "i'm broken and can't be saved #fallenangel" and then post some weird depression edit. that's what the meme is about