I find the idea of being all apologetic and conciliatory toward Sally *deeply* weird and horrifying. Tell her that it was a horrible and hurtful thing to tell someone who'd just been through serious trauma and injury that she'd prayed for their death, and then you're shocked she thinks that after saying that, she would still be a friend or invited to weddings. Tell her this before witnesses. Uninvite the whole damn work group, if they are insufficiently shocked about this - actually, write them off anyway, they decided a wedding invitation was grounds for shunning and professional sabotage without even asking if there was another side of the story. (On rereading, apparently it's only the women on the team who are doing this? And all of them are acting as a Sally-aligned monolith? Something very creepy is going on there, but it's not your job to fix it, so resist getting drawn further in.)

Look for a new job. Tell the manager the whole story. And do NOT cover for Sally anymore. She made this bed, she can fucking well lie in it.

Harmony is dead and gone. Go for justice and a clear conscience.

Also, send Ted to therapy, because he needs help working through the fact that Sally's horrifying and disgusting words were a reflection on her and her values, not on Ted's worth as a man. Which LW seems to have missed completely? Like, there's no outrage there? No "you told my fiance you prayed for his death - you're dead to me. Fuck no you can't come to my wedding." Maybe step up a little in your partner's defense, LW, instead of focusing all your attention on appeasing and placating the woman who told your partner she prayed for him to die.