Their is an enormous wealth of evidence showing that we transition from death, our soul leaves our body. So it appears their is nothing to fear about death we will not it appears go into a state of oblivion for eternity. Of course psychical researchers could be wrong and that all of the evidence gathered from psychical research supporting survival could all be just self deception and fraud etc. But that appears to be unlikely but of course we can never ever completely rule out fraud and self deception and delusion. Even if super psi was real this would not imply that death is the end either this would show that information survives death and it gathered into some medium in space. Of course that wouldn't be personal survival but it would be survival nonetheless.
I quote from Raynor C. Johnson
"To sum up: we have enough trustworthy evidence to anticipate our survival of the change called death. If our conception of the Self as a hierarchy is true in broad outline - as I believe it is - we have enough to anticipate a great deal more. For myself, Birth and Death seem to be respectively the great Exile and the great Returning Home. I expect, when the immediate shock of change is over, to find myself with a body familiar to me (because it has always been a possession without my realising it), in a country from which come thronging back to me welcoming echoes of old familiarity. It will still be a world of Appearance; but since one veil at least will then have fallen from the face of Truth, I shall expect to find myself more responsive to her Eternal Beauty as I set out again - a pilgrim on the endless Way".
I agree 100 percent, this was his view back in 1953, now their is even more evidence that continues to accumulate more and more.