Jar Jar Bricks said: In other words, even with failure as his greatest fear, he can still believe that the Jedi are doomed to fail in TLJ, thus why he wants them to end.
Even more: He could have been specifically afraid that his new order would fail like the old jedi order did.