In his onscreen appearances, Bail was always kind of a non-character beyond the basic traits of being a good-hearted senator who likes the Jedi and democracy. But yeah, the new canon has unintentionally written him as kind of a doofus.

Besides the things you mentioned, there’s also the fact that he sent Obi-Wan of all people to save his daughter when he has loads of money and influence at his disposal. Also, him sending his daughter directly into the Battle of Scarif is hugely incriminating. With stuff like that, it’s a miracle he lasted as long as he did, and realistically, he would have been “disappeared” by the Empire much sooner.