Actually I agree. When prohibition was passed in this country, there was an explosion of alcoholism. I'd rather see the DEA eliminated or greatly downsized and spend the money on better things. The current system certainly isn't working that well.
Well, there was an explosion of drinking, yes.
Per Capita Consumption of Alcoholic Beverages (Gallons of Pure Alcohol) 1910-1929
But that only brought the consumption level back to what it was before Prohibition (actually lower).
There is no relationship to drugs. Drug use declined when we got serious about enforcing the Controlled Substances Act.