The reason prohibition failed was because they made something that was already legal, illegal and that God Himself doesn’t even prohibit alcohol consumption (for anyone other than pastors). Just the abuse of it.
Does God prohibit smoking weed?
How's the Bible deal with incest and alcohol? Handing over one's daughters to be violated by strangers?