@ DaasYochid .
It hard to play a numbers game and say whether it was “rov” or just many. Yes in reality there are 3 sides,
1) Totally opposed to cooperating with a state even after the fact.
2) Opposed to Zionism but once its here cooperate. (General todays and the past 50 years agudah shita)
3) Pro Zionism and founding a state of our own but anti being secular. This had many gedolim in its side too. After the state was founded and this question was no longer relevant a large chunk of this group folded into the group #2 above (agudah) while a few went to mizrachi. Today this is no longer a discussion but many in this group that joined agudah. A prime example is the rizyna rebas who were all clearly in this group. Today Boyan, sadigyur, bahush, hystain, Shtefnesht etc are all mainstream agudah.
So yes R Reuvain and probably R Aron too were against the idea of having a state. But for example R Aron Z”L father in law R isser Zalman was very pro Zionism and was an extremely close friend of R Kook Z”L. in fact R Aron’s brother in law took over as RY of Hesder after R Kook Z”L.
All this is to say that all 3 sides of the debate are holy. As you note, the 4th side which is todays crazy NK is not holy.