> I'm afraid the latest spate of "recognizing the state of Palestine" is not, in fact, a sign of coming relief for the people there, but rather a spigot to relieve domestic pressure to engage in substantive actions (sanctions, pressuring the US and other suppliers of arms to engage in sanctions, let alone sending peacekeepers or no-fly zones).
I don't think recognition as a State would really change anything. If at least one of the permanent members of the UN Security Council will veto everything that comes up, the UN won't effectively intervene in the situation. Military intervention in such a case is unlikely, unless at least one permanent member is willing to join an intervention coalition. Looking at conflicts the US has been involved in, it usually lines up around the lines with US maybe with their usual friends vs Locals or Locals and Russia and friends. The only one I found where the pattern was when France started sending arms to Nicaragua while the US was supporting the other side [1]. Unless Russia or China wants to support the Palestinians militarily, or the US decides not to no longer support Israel militarily, there's not much chance of outside intervention here.
Given the outside countries can't effectively intervene, recognizing the state of Palestine at least sends a message, that maybe hopefully influences the US?
[1] https://www.csmonitor.com/1982/0715/071566.html