A bodyguard played properly is going to die eventually, being that the point of the vanilla bodyguard ability is to sacrifice yourself to prolong the life of someone more important.
If the mafia end up killing a bodyguard because the person claimed it isn't a total loss.