…if it is a time-bound prohibition, maybe in the order of a few weeks, so society can rethink about their consumption habits.
Indefinite prohibition, of the kind that was amended in the US constitution, denies the human desire to consume alcohol and pretend it can be legislated away. A cursory reading of the Wikipedia article on the capital-P Prohibition showed lasting effects in alcohol consumption (I guess, good in the sense that there’s changes in domestic abuse patterns, for example?) and organized crime (bad, with Al Capone and people like him)
The relationship between alcohol and violent crime is so tight, the police are prevented from keeping statistics on how many violent crimes are committed by drunk people. Thanks to a significant alcohol lobby.