Place it after the kill cam or death screen, once the loss is clear, following an Enemy Spotted cue for the ambush and before a No God Please No reaction to close the sequence, keeping the focus on the failed raid itself.