It's not useful to judge prohibition in a single dimension of "work well" to "didn't work". Sure, cirrhosis rates went down significantly but organized crime (a disease of its own) was gifted a torrent of money to fuel other activities.

It reduced harm until it started to increase harm.

At the end of the day human vice isn't going away.