Was it wise or unwise to end Prohibition? I say wise.
It was wise to end Prohibition of alcohol, and it would have been wiser yet to have never adopted it.
Would we by the same token be wise to end prohibitions of other popular mind-altering substances such as marijuana? I say so. If not, why the difference from alcohol policy?
Different substances have different effects and consequences and thus logically lead to different policies. At the level of the entire population, marijuana is more harmful on the net than alcohol, with heroin and other opioids much harmful still.