It wasn’t working even before it was repealed. Alcohol was still widely available and consumed.
I put “work” in quotes because even the staunchest Drug Warrior will say that Prohibition didn’t “work” while saying the Drug War does, despite the exact same results.