Prohibition actually cut down on the consumption of alcohol. Problem is that it just created whole criminal enterprises for some dodgy, risk-taking entrepreneurs.
Plus prohibition made the Kennedy family rich. They didn't get caught and Capone did. The rest is history.
It certainly cut down the number of people who were using it harmlessly. But freedom-loving people shouldn't consider that a useful objective. There were still plenty of problems caused by alcohol consumption during prohibition; a shift from predictably-formulated drinks like beer to more variably-formulated variants of gin may have made these worse.
There were about 100,000 speakeasys in NYC, where you could get a drink during prohibition....they were really shutting it down!