We do not have to wait for thousands or millions of years until the Day of Judgment at the End of Time. Definitely, at the moment of death, we will enter fully into that Day Without Evening. I do not know what physical theory prevails right now, but according to some theories of the universe, there is an original expansion and then the universe contracts back into a single point. Metaphysically, this is the Quranic or the prophetic view. Creation is not just an endless dissipation into space.
Creation has an actual rhythm to it.
It reaches a certain point and then returns into its Source. The Big Bang theory does not say anything about the Source. As human beings, however, we can and must talk about the Source. Creation returning into its Source is not a disappearing, a cancellation. It is the ultimate fulfillment of creation.