I am not sure about this Wall as the source of John's power. The multiverse or Omniverse is big. After all other works that John bring came from videogames and anime. So his system is beyond the Wall.
I don't think John would die with the wall breaking apart since I see him getting depowered and maybe severely weakened to the point that he is close to death, but I don't see him dying