While an argument can be made from both a scientific and public health perspective that alcohol is bad, that doesn't necessarily mean a government should therefore force people to make the "right" decision about their health. People who are in favour of the legality of alcohol are not anti-science or against bureaucracy, they're just people who value freedom over public health in this specific instance.
We're living in a strange time at the moment where we claim to value democracy, yet we simultaneously don't believe the public are informed enough to have any opinion about much of anything. I saw this start around the time of Brexit when people were getting annoyed that the government decided to listen to the opinion of the public rather than just doing whatever economists advised them to do. Today with COVID we see this more than ever, but at least in the UK there has been a steady trend towards our elected officials just deferring to unelected and often untrusted experts instead of representing the views of their electorate. While I think it's important we have public experts offering their thoughts on complicated decisions, I also think in a democracy we should embrace our liberty to reject the opinions of those experts for whatever reason.
We have to acknowledge there is no expert arguing on the side of freedom despite the fact many of us quite strongly value being free.