It was definitely sad to see… On the other hand, Holmes was also a heavy smoker and, although he did quit cocaine in both the stories and the series (but at different points), he had abused his body for years. So that actually worked in-character as well.