It was.
If the goal was to reduce the amount the average American drank alcohol year over year (and that was the goal) it was an overwhelming success; not only during prohibition but thereafter as well.
Banning stuff and then enforcing the ban works really well and we have tons of evidence of it working; not just in the US but literally world-wide.