I think if people had to drink prison hooch or wait weeks to brew their own substandard beer, as opposed to drinking bottled craft beer or tasty wines there would be less alcohol consumption.
The history of the US prohibition says otherwise. Or rather, while overall consumption of alcohol probably did drop, the effect on society of pushing it underground was not positive.
From memory, alcohol consumption actually _increased_ during prohibition.
I suspect while that might be true initially people would soon get really quite good at it.