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