There is a wealth of data showing that alcohol consumption has negative health impacts and is correlated with shorter lifespan. Contemporary Prohibition arguments also mentioned the positive social aspects of banning alcohol (often in early feminist terms, such as arguing that a woman with a sober husband is less likely to become homeless or to suffer domestic abuse).
On the other hand, there was a clear conflict between individual freedom and Prohibition. And Prohibition encouraged a freewheeling black market and organized crime.
Prohibition is (IME) taught in US schools as a failed policy brought on by moralizing, pearl-clutching types. But there have been studies showing that the rates of alcohol-related diseases declined during Prohibition and increased afterward (such as https://www.nature.com/articles/140020c0)
I thought this would be a fun weekend thought experiment.
Instead of a binary, you can also ask what policies would they have supported. Perhaps they would have supported a policy that preserved individual choice while creating substantial friction between users and drinking as well as limited the profit incentive get people to drink more.
It's worth noting that the most lethal drugs are the legal ones (measured by total fatalities). Take tobacco for example. It's been around for millennia, however we did not get the modern tobacco epidemic—which killed 100 million in the 21st century—until A) mass manufacturing of cigarettes, B) heavy engineering of cigarettes to be hyper palatable and addictive, and C) modern mass marketing. This is why I'm partial to the tobacco endgame proposals that focus on removing the profit incentive to get people to consume addictive and/or harmful substances. Consumption in society can be managed to a point of acceptable trade-offs by friction and nudges once you remove the asymmetry of multinational conglomerates spending billions of dollars to get adults (and yes, youth too—the majority of smokers start when they are minors) to consume tobacco and alcohol whilst effectively lobbying for much weaker regulations than recommended by the public health community.