Which movie ended with a man shooting a woman dead with a shotgun then has sex with her, then commits suicide?

The couple is white, they're in a bedroom or hotel room, it takes place in the day and the camera is at an aerial view. It's an old movie, it has to be older than 2002. It could have been a biography about a rockstar. I'm not sure. And I think the woman was blonde. The guy was brunette. The last shot is the woman on her back, laying on the floor and the man is dead on the floor as well. They're both beside the bed.