It's not a myth and a few simple google with give you plenty of evidence. Here's a few:
- Cancer
- Weight gain (alcohol is more calorie dense than sugar)
- Birth defects
- Drunk driving: 10K deaths a year
- Violence / sexual violence
- Overdosing
- Withdrawal can cause death
- Did you know date rape drugs wouldn't work without alcohol? (2) It's only the combination with alcohol that causes the victim to pass out.
If you actually look at how alcohol has an impact on the body, it's effectively a poison. It has no medical benefits and only consequences. The whole red wine thing has nothing to do with alcohol but some of the enzymes in red wine specifically. Just drink grape juice instead.
I really don't care if you give yourself cancer. That's a personal decision but consumption of alcohol leads to so much crime and impact on others. Weed not so much. As a society, we've made a decision to tolerate it but it's still there.
1. https://drugabuse.com/blog/marijuana-vs-alcohol/
2. https://www.drugs.com/illicit/ghb.html