No it didn’t. Alcohol sales increased during prohibition. A lot of people got rich through the sale of alcohol flooding through from Canada.

Banning things has never worked. Just look back at history, it just drives things underground.