Folks, Noah and Ham did not become involved homosexually. If so, then it would have been ridiculous to curse Ham's son instead of Ham!
There is a clue as to what happened, and that is in the word 'the' used in the most ancient manuscripts when describing the cloak that Shem and Japheth covered their father with. Ancient Jewish legends ascribe that cloak to be the one God made for Adam which Noah then brought down through the Deluge. This cloak, or a cloak like it, may well have been a sign of authority. A cloak, or mantle, indicating authority has been used ever since in many, many cultures.
Noah was a righteous man. He was the family authority. He did not MEAN to get drunk. However, if he thought it was grape juice he was drinking, he would have spat it out after the first sip. So he knew it was wine, and he had made it purposely.
But the Ark had landed on top of a mountain, and there is a strong possibility as well that the air pressure after the Flood was decreased from before the Flood. That means that the air pressure where Noah was was significantly less than before. Anyone who has ever had wine at an altitude vs. at sea level is going to be way ahead of me here -- at an altitude, where there is less air pressure, one gets high or drunk much, much faster than at sea level.
It appears that Noah had what would have been an innocuous cup of wine before the Flood and drank it relatively fast. Why? Because he did not feel the effects until it was too late, and wine acts relatively quickly. So at the first strong flushes, he may well have divested himself of his cloak, in the privacy of his tent, and then passed out. Whether he was naked as in 'bare naked' or simply without that cloak we honestly don't know.
But the brothers covered him up after Ham discovered him. And that is why Noah cursed Ham's son -- the authority was NOT going to pass down through Ham's family, but instead they would become servants and slaves -- the opposite of the authority Ham may well have tried to steal.
Granted this goes back to Jewish legend, but it does make more sense than some of what has been stated here in this thread!
And the little 'the' in front of 'cloak' or 'mantle' (depending on your translation) regarding Noah's cloak may well be the clue supporting that ancient story. The fact that Canaan was cursed also supports it.