
This card is quite effective to "make use of" your ample 9 health, escaping defeat by horror. In Carcosa campaign that the card came with it is actually hard to try to get killed by damage when all hope is lost as you are trying to choose the right kind of trauma.
Also cannot be overlooked is how Mythos Phase draw is reduced once you are gone. If the works are already done then the game could be easier with you (and perhaps some enemies) out of the way, it is suddenly more peaceful. You can have a more deterministic last few turns where you are gunning for extra VP as well as getting out alive at the edge of doom clock.
However, if the remaining investigator can't win on top of your sacrifice, you may doubly suffers new trauma (could be horror still) from the campaign resolution in addition to 1 physical trauma printed on this card. Yikes!
Also sometimes the campaign booklet prepares extra detailed resolution for investigator who were defeated and who weren't, so relying on the remaining player to drag your dead body to finish line requires some scenario knowledge. Card is better on Hard / Expert and with campaign knowledge.
It is also possible that a new player joins mid-campaign with 0 XP (or existing player got asked by the campaign to choose a new investigator) and this card can be quite strong for such an investigator coming in with underpowered gears but with fresh trauma. I'm glad the game has some niche solution for niche situation.