US support for a UNSC resolution along these lines would be the principled, correct thing to do. But at this point it would amount largely to a symbolic act and wouldn't change much at all. At best, it would convey to the world that US presidents, either out of power or about to be, recognize the truth about Israeli tyranny over the Palestinians just like most reasonable people do, but are always constrained while in office by the Israel lobby from doing anything about it.
And even if Obama does it, Trump will denounce the move, pledge to veto any similar resolutions in the future and insist that it doesn't represent US policy. It may increase pressure on Trump and spur him to act on his pledge to move the US embassy to Jerusalem, which would be a disaster. It will end up being seen as largely a personal act of President Obama.
If Obama had had real courage, he would have agreed to support such a resolution long ago, before Trump was elected, and risked political capital to help the Palestinians. He did neither. And he wasn't going to do anything that hurt Clinton's chances or risked alienating the Democratic Party donor base.
President Carter is to be commended for speaking out for Palestinians during the decades he's been out of office. Sadly, though, while the Camp David Accords bought (at tremendous cost in US taxpayer treasure) a cold peace between Israel and Egypt, history will record the agreement as a separate peace between those two countries that abandoned the Palestinians to decades more of occupation and despair. In no small measure, Sadat paid with his life for having done the deal.
One final point: in President Carter's op-ed he calls for a demilitarized state of Palestine. Why would or should Palestine agree to have such a restriction imposed upon its sovereignty? Will Israel guarantee its borders and security, ensuring that the state of Palestine exist in perpetuity as an impotent vassal appendage to Israel? It presumes that the tiny, impoverished state of Palestine would pose a realistic security threat to Israel, the greatest military power in the Middle East, when it is Israel that will pose such a threat to Palestine.