You asked

how did the exilic experience influence john's vision of a new jerusalem where god dwells with humanity?

Reading with you…