Tragic to somebody, I guess.
Probably family, especially the parents. In the case of Amy Whinehouse, I don't think many are concerned. She kind of became an infamous druggy, and through that a joke. Her parents are probably sad if they are not estranged. As much grief as she has gotten she was still their daughter, and they might feel guilt about her problems.
My uncle had a girlfriend who died this year. I didn't care. Felt bad for my uncle, though. She was a drug addict who he continually asked to get help. A day or two before she died they had an argument in which he warned her she might end up killing herself. She'd been doing this since they had started dating, but it got progressively worse. She stole prescription pads and sold his clothing. When he was ready to leave her, she ended up getting pregnant. She had her child, and proceeded to being a crappy mom. She would use her daughter as leverage to get her way in situations. Such as leaving her daughter with somebody else when going to her grandmother's (who hadn't seen her yet) birthday to get back at her father. My uncle had caught her cheating on him. Most concerning was when he had left their daughter with her for a weekend while he went on a trip to find out she had been getting plastered and having sex with some dude. Despite saying she'd stopped he found out after her death she was still having an affair. He also found shop lifting tickets she kept in a file and never paid off.
My grandmother and I seemed like the only people who weren't crying at her funeral. I doubt many other people knew of the drama, though. In the end I was neutral. Her story might sound tragic, but sympathy didn't help her when she was alive.