I mean, your source there is telling us that cannabis and hallucinogen use are up, vaping (weed and nicotine) is up and smoking is in decline.
Hallucinogens are generally considered not very addictive, they are drugs that people use infrequently and their direct health effects are usually pretty minimal - LSD for instance is a mild stimulant and vasoconstrictor, but that's no real health worry for younger users. There are mental side effects in a minority of users (HPPD etc).
Compare this to tobacco which is well known to be one of the world's most addictive substances and kills fully half of lifetime users, I'd say a society in which people 9% of people used hallucinogens in the last year is preferable to one in which (like the US was in 1965) 42% of people smoke daily.
Cannabis consumption doesn't have to involve your lungs, people consume all sorts of edibles and drinks these days. Vaping cannabis is definitely worse for your health than abstaining from both vaping and smoking, but it doesn't contain the combustion products from burning plant material. Smoking cannabis; well I honestly don't know how that compares to smoking tobacco in terms of health risk, but it is less addictive and users are less likely to be "pack a day" types than they are with cigarettes AFAICT.
Vaping nicotine, similarly, is widely considered worse than not vaping nicotine and users may be more prone to respiratory infections, plus there is often poor quality control on ingredients. But again, tobacco kills half of lifetime users.
So yeah, if I had to choose whether to have higher smoking rates or higher hallucinogen and weed use rates in society, based on expected health outcomes, I'd go with the hallucinogens and weed.
If you want to read about the comparative risks of drug use (including tobacco and alcohol, but written prior to the explosion of vapes) I highly recommend "Drugs without the hot air", a book by Prof. David Nutt, one of the UK's foremost experts on the topic. The general takeaway is that heroin, cocaine, tobacco and alcohol are the worst, and that most other drugs slot in below there somewhere.