If prohibition was so successful, then why was it revoked less than 10 years later?
Because the power structure of the nation absolutely hated it. Washington D.C. was against it in the first place, and congress spent most of prohibition drunk on illegal booze. Same with the financial titans of New York. (and all the other major cities) The real power blocks of the Nation simply saw it as a "tantrum" that had been thrown by all the ignorant "hoi poloi" in what we now refer to as "flyover country."
Prohibition was undermined right from the start by people who disagreed with it, and worked hard to both violate and profit from it.
Prohibition was a bad idea. Too draconian in implementation, and too wrong headed. Alcohol had been part of mankind's existence for 10 million years, or so articles i've read have told me.
It was foolish to believe you could eradicate it in a few years by voting it away. If their goal was to get rid of alcohol, the methodology they are currently using to eradicate tobacco usage would have worked much better.
A slow gradual squeeze might have produced eventual success when that fast, draconian prohibition simply created a resentful backlash and quick paths to profit.
Not that we should have done it, but the concept of "prohibition" might have worked had it been implemented in the slow squeeze "Python" sort of methodology, such as slowly taxing it into oblivion.