Lifetime ultra heavy pot smokers for example face significant lung cancer risks, though very few people are heavy daily pot smokers for 50+ years at this point.
At the other end, 1 glass of wine every day for 60 years is as far as we can tell on net harmless. Where even light daily pot smoking still causes some lung issues on those timescales. So yes, alcohol in and of it’s self can be deadly but it’s not nearly as bad as these comparisons generally suggest.