Interesting assessment and I will elaborate and also we have had numerous in-depth discussion on this forum regarding that matter, as many persons are taught incorrectly by some suspicious organization that the wine in the bible was simply "grape juice". It clearly was not, and drunkeness was largely directed from the Lord as to proper usage and social consumption as well as medicine uses for alcohol.
I will direct you to Noah and the wine drinking he had performed after the flood and also, please do not judge Noah, the extinction of the human race during his time and the arrival after the flood must have been heroic and troubling both:
Genesis 9:20 And Noah began to be a farmer, and he planted a vineyard. 21 Then he drank of the wine and was drunk, and became uncovered in his tent. 22 And Ham, the father of Canaan, saw the nakedness of his father, and told his two brothers outside. 23 But Shem and Japheth took a garment, laid it on both their shoulders, and went backward and covered the nakedness of their father. Their faces were turned away, and they did not see their father’s nakedness.
24 So Noah awoke from his wine, and knew what his younger son had done to him. 25 Then he said:
“Cursed be Canaan;
A servant of servants
He shall be to his brethren.”
26 And he said:
“Blessed be the Lord,
The God of Shem,
And may Canaan be his servant.