That is a caricature. You can invest in naloxon if you are worried about that. Or better yet, go the route of Switzerland and provide safer alternatives for life long addicts. It does absolute wonders for their quality of life.
The crux just is, that in this discussion, sober is the most important metric for a lot of people. Overlooking not just the end of life problems, but the simple truth that without drugs, a lot of those addicts would have killed themselves already. Drugs arent just a fly trap for the careless, they are a haven in the storm for the desperate. A shitty haven for sure, but in some situations less bad then the alternative. That distinction explains a lot of why all the warnings get ignored and all of the "education" on the topic finds only deaf ears.