It is believed by some, and I am one, that Noah did not set out to deliberately get drunk. We have to remember that the conditions of the earth had changed drastically. The fountains of the deep were broken up and the windows of heaven opened. (Gen. 7:11) The windows of heaven was not just rain but was the canopy of water that existed around the earth. These are the waters above the firmament. (Gen. 1:6-8).
These waters above acted as a filter from the suns rays. And it created an atmosphere on the earth producing a mist which watered everything. (Gen. 2:5-6) So, the flood of Noah was the first time people saw rain or water come down as it did.
But once the waters above were broken up, then the suns rays come directly to the earth without any hindrance or filter. And immediately you see the ages of man start to decrease. He lived hundreds of years before the flood, but now it dwindles down to less than a hundred. The rays of the sun increased the aging process.
And it also increased the fermentation process of grapes. This may well explain how Noah got drunk. He could enjoy a lot of wine before and not get drunk. But he didn't realize that that now had changed.
The sin in this story was that of Ham, not Noah.
Quantrill