Moderate alcohol use is associated with some cancers, but is also associated with cardiovascular benefits. On net it’s as far as we can tell neutral.

All opioids build tolerance but not resistance. Overdoing is sadly common in very long term users even of medically sourced and therefore clean drugs. Even clean heroin by itself is vastly more deadly than Alcohol for average users over moderate to long timescales.

Which is why you need to compare habitual long term users of drug X to habitual long term users of drug Y.