Cersei will be on board to team up for the war against the wights not because she is interested in saving her people, but because its the only way she can think of that the dragons could die. The Night King already killed one dragon, if another one or two dies Dany's chances of winning the Iron Throne are hugely diminished.