Genesis 9:24 - The Popular Commentary by Paul E. Kretzmann

And Noah awoke from his wine, and knew what his younger son had done unto him. As the intoxication wore off, Noah awoke to soberness and found out what Ham had done, probably by reason of the dress which covered him. It was doubtless with deep humiliation that he became fully aware of the role which he had played. But to this was added just anger at the disrespect of Ham.