I downvoted you because while it may not have been successful at getting Americans to stop drinking, it was effective at reducing violent crimes caused by drinking, as well as the negative health effects such as liver cirrhosis. The anti drug control crowd has done a great job commandeering popular opinion on this topic. I found this (non-academic) article informative to this end.

https://www.vox.com/the-highlight/2019/6/5/18518005/prohibit...

Edit: to the downvoters, I look forward to future academics and politicians being absolutely shocked when it turns out the absence of evidence is in fact not evidence of absence and there are a myriad of negative health and societal consequences from legalizing marijuana use