And yes, there are many at present who sleep through this experience, swept up into a higher repose awaiting further incarnating, dreaming dreams or living nightmares of what was their former life.
Consciousness is purchased/acquired through selflessness: works and thoughts of good character, of kindness, of charity, of such purpose that is for the whole of Humanity and/or the other kingdoms below and above in concert with Christ.
For it is that we cannot see, cannot perceive, that which we do not know, that which we have made a certain space for within our souls. And it is goodness that enables us, and delivers us into mutual fellowship.
And so with that said, you can be assured of the pleasantness of the spiritual realms: cordial and genuine, and above all, serene.