…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)
It taught us what happens when you try to make it illegal. Afterwards, it was legalised again, but with some government oversight. Seems to have worked out better than to prohibition era.
Strangely, drugs are still illegal though. I expect that having some government oversight with drugs should have a similar effect.
It is important to note that alcohol becomes a dependency. You cannot dry out like Amy Winehouse tried to do:
It will kill you.
You see, alcohol causes the body to stop creating GABA inhibitors. Without these inhibitors, the muscles will use all available energy.
This is why drunks get the shakes.
Without these inhibitors, your heart is going to pump, your diaphragm will vibrate, and your brain will burn.
You cannot just abolish alcohol. You are literally lining up a death sentence.