Brienne of Tarth executed Stannis because he was somehow involved in his brother's death. Given how much advice the Red Woman gave him, I would believe that it had something to do with her.

[Oh. Right. Robb won't know of Stannis' death either. Surprise? There are no Baratheons left now. At least not trueborn ones.]