Question: was Zeus being serious in Destroyer of Light when he said he would leave hera for demeter?

Yes. I think he was desperate at that point. By Demeter was right. If she accepted, it would open up the possibility that he would do it again to her when some other goddess held the earth hostage, essentially.