According to the Bible Noah was 600 years old before the flood. After the flood he planted a vineyard, drank the wine and got drunk. So he had never drunk wine before the flood and didn’t know what would happen if he drank too much?
No death, no corruption, and no decay in The Garden. Therefore no yeast. Therefore no risen bread or alcohol...
The Bible doesn't say. My guess is that Noah knew exactly what he was doing.
Drinking wine in moderation is not a sin. Jesus was accused of being a winebibber Matthew 11:18-19. And Paul recommended wine for digestion.
I understand that wine today probably has a higher alcohol content. But wine in Jesus' day was considered a safe drink relative to water because of the alcohol.