It was a huge failure.
Society figured out it was a failure and 14 years later it was repealed. Thus the 21st Amendment.
Below are pages linking to information about alcohol prohibition. But, for sure you should read, National Prohibition of Alcohol in the U.S., by David J. Hanson, Ph.D.