Sort of like Sal Tessio's death in the first Godfather. We see all of the other Dons be wiped out in a bloody blaze of glory and vengeance, Carlo strangled to death for his treachery...But Sal Tessio's betrayal is handled with dignity, even when outed he's treated with respect (Cicci saying to Tessio "Excuse me, Sal" as he pats him down), with a quiet march to the car and to his death off screen. Because he'd been the Don's friend for so long he got a dignified death.

Pussy was sort of the Tessio of the Family, the stoic sort of stone wiseguy who'd been around since "the beginning", was more level headed and smarter than some, and beloved...And he fell by making a deal with the Enemy because he thought it'd allow him to continue eating.