…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)