Even ignoring that bans tend to make things "cool" to young people, bans done wrong tend to simply concentrate roughly the same or close to the same amount of harm.

Sure, less people habitually got drunk and beat their wives/kids during prohibition, but approximately the same harm still happened, it was just concentrated in all the people who had their lives ruined or got killed by the gangsters or the feds.