You can oppose "prohibition" without supporting drug use. Most drugs are clearly harmful to the human body. This includes cannabis and alcohol. Hallucinogens can cause lasting psychological changes. Maybe you shouldn't be afraid of drug use, but you should be wary.
And I can't think of anything much more self-destructive than binge drinking. It's right up there with opioids.