The CEO's antics, no matter how disturbing, simply aren't most people's top concern when making a product choice. This may seem crazy to the hyper-political crowd but most people really do not see themselves as being part of this war where every single decision they make in their lives has to prioritize their side.
When choosing a social network, probably the top priority for most people is where the people they want to talk to are.
If CEO antics were the thing that mattered, I would certainly choose Bluesky over X. But the reality is the tech community -- at least, the part of it I want to interact with -- is mostly on X. Many of us tried to switch to Bluesky for a bit but ironically got pushed back to X due to Bluesky culture being hostile to tech and especially hostile to AI. I'd post the same non-political tech thing on X and Bluesky and get lots of interesting feedback on X while getting screamed at on Bluesky, so I stopped posting on Bluesky.
Would love for this to change but it's a hard problem.