Read: Genesis 8-11
Marked: Genesis 9:20-22, And Noah began to be a farmer, and he planted a vineyard. Then he drank of the wine and was drunk, and became uncovered in his tent. And Ham, the father of Canaan, saw the nakedness of his father, and told his two brothers outside.
We are not told specifically what is was that caused Noah to curse Ham, and his descendants, V25, but it must have been more serious than Ham seeing his father uncovered.
Whatever it was, it occurred because Noah was drunk. I think it is better to avoid intoxication than to lose dignity.