Mik, you are forgetting that there is also religious Zionism. Even secular Zionists, as Rav Kook (who was a gadol) pointed out, were Hashem’s tools. If you want more gedolim in favor of Zionism how about the Netziv, Rav Shlomo HaCohen of Vilna (who greeting Herzl with a sefer Torah in his arms) and Rav Meir Simcha (who personally contributed to the JNF). As for the Chofetz Chaim, he was not anti-Zionist. In fact, he had planned to make aliya to Petach Tikva (which was founded a a Zionist settlement)but for some reason could not. He was only opposed to anti-religious sentiments among some Zionists.
In any case, the State of Israel is a fact. The only question is whether we are going to do our part to advance the Geula and bury our heads in the sand or worse support the enemies of Am Yisrael as do certain apikorsim.