I believe he was honest when he spoke about how Twitter should be a neutral public square with no political leanings and so on. But it's one thing to want something, another to have a plan for it, and yet another to execute that plan properly.
He thought he can improvise and good things will happen. Instead he got tricked by wingnuts into destroying his $44B investment.