Having worked in Drug and Alcohol education/treatment for a number of years, I have no sympathy either. Billions and billions of dollars have been put into education on this matter and yet there are those who don't want to listen. And the education isn't always a matter of going "straight edge", many times it's a process that makes a person aware of potential risks. Upon hearing/knowing those risks, the person then makes a choice: they can use and entertain those risks or they can not use and avoid that particular set or risks in their life. I think it appears to many, myself included, that entertaining risks over something as ridiculous and unnecessary as drug use/abuse is just an unnecessary, unproductive waste of time. When an overdose occurs I think it's easy to say "tough shit" because it's such a fucking waste of life to get into that scene. There's no positive end product from the direct use/abuse of substances. It's not like those dangers we entertain when we travel, play sports, etc. The end result, at best, is a numbing of the person. It's unproductive activity and that merits a "who cares" response from those who think people should aspire to more. It's like bungee-jumping. If the rope broke and he cracked his skull, tough shit there too. Many things carrie an inherent risk but we need those things to survive as a society. Drug abuse certainly falls into the category of "useless behavior".
As for the idea that "if it was XXXX band member you'd be singing a different song...Ingo Schwiktenberg of Helloween jumped in front of a train over his abuse. I was sad at the loss of good drummer from a band I liked but, again, I have to say that "that's what you get" for all of your drug using. I don't like it, but it's a common enough result that it can almost be expected at this point.