The real problem is that in general, across the board in all entertainment mediums, the plot device of using female death to motivate male heroes is very common.
Sad but true. In this case we had a series with a strong female lead who got fridged in order to explore the reactions of her crew and in particular her lover Chakotay who then became the main protagonist - back to the "natural" order of things.

I have a friend who attended this year's Fedcon, and she reported to me that both Terry Ferrell and Martha Hackett were unhappy with the way their character's deaths were written. Both thought their characters should have died fighting.
Never thought of it before but Seska was such a strong character yet she ends up mortally wounded while sitting in a chair on a bridge then dies while crawling to her newborn child. O-kaaayyyy.....