…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)
I don’t think treating addiction like a health issue implies some libertine approach to drugs, there’s plenty of room for regulation.
The real problem is that allowing addictive drugs to proliferate in a society where a large percentage of the population wants to die is a good way to collapse the economy. Why keep suffering when there’s a way out?