After weeks-long effort, Herzog beseeches sides to seize opportunity for ‘formative constitutional moment’ and not ‘destroy country’; cabinet secretary swiftly downplays it