Wide scale substance abuse causes immense harm to innocent victims. Moreover, victimization and social calamities and breakdowns in general often bring a turning away from religious faith, as happened after the Black Death, the 1755 Lisbon earthquake, the US Civil War, and World War One. The mystery of evil takes an acute form in such instances, making it hard to escape the question of why a good deity would permit such harms.
Was it wise or unwise to end Prohibition? I say wise.