Agree with the sentiment of your first paragraph. Unless Bernie comes out of this whole thing smelling like a rose (unlikely at this point), then I expect this will be JB’s last season. It was soon to happen anyway.
If the investigation turns ugly, then he could be gone sooner (probably self imposed). I think more for the reason that he should have known, than for his spirited defense of Bernie. Please also note that if it turns ugly, it could mean trouble for Hopkins as well. He’s been around Bernie almost as long.
As for your second paragraph, I totally disagree, in fact I think the opposite. The media love intemperate “color” commentators. Only when they totally screw up, like Jimmy the Greek and Rush Limbaugh are they shown the door. Or if they become a little too lewd, like Marv Albert, will they be sent packing - reluctantly. In IMHO the present controversy makes JB an even more attractive candidate. Other "controversial" characters – Cosell, Madden, McGuire. Vitale. Knight, Garagiola, Meredith – to name a few.