...But only after he shagged her...
Rosie was working for the enemy. She might not have been doing it willingly, but she was leading 007 to his death, it was only the fact that her fear of Samedi was greater than her fear of Bond that made her blunder into the trap that had been set for 007.
I think Bond was more irresponsible with Solange, Jill Materson, and Corinne Dufour.
As disappointing and moderately unexpected as Judi's M dying was, I wasn't as emotionally hurt by it as many other much younger female characters and male side kicks dying (which is sadder on principle).
Elektra King being shot by Brosnan's Bond was pretty 'what 'da fuck?!', but I wasn't really that emotionally invested in her, especially when she's a villain and when other villains seem more tragic: Xenia Onatopp (an attractive and intelligent young woman who had lost against her severe mental dysfunctions), Eliot Carver (a very lonely, terminally unsatisfied guy at the top of the corporate ladder who cannot develop meaningful relationships), Silva (suffered unimagined torment in PRC custody), Le Chifre (pushed into a corner by powerful crime syndicates), and Alec Trevelyan (haunted by a historical massacre and family annihilation).