I think I understand. It’s not necessarily the idea of Heaven that scares me, it’s the idea of eternity. This limited world is all I know, and passing from this one and living forever in the next is… wow.
I think I can understand where you are coming from re eternity. This limited world with consistent beginnings and then endings is probably all most of us, if not all, have ever experienced. The concept of a life that never ever ends can be scary at first glance as it were - a beginning that never has an ending - until one just rests trustfully in The Lord.
Death has an element of the greatest of adventures possible, since it will be an experience that one has never had before. According to St Paul we could not imagine in most our wildest dreams what awaits us in Heaven "
[9] But, as it is written: That eye hath not seen, nor ear heard, neither hath it entered into the heart of man, what things God hath prepared for them that love him.
1 Corinthians 2:9] "
Probably the kind of death could present problems if I let it and let my imagination run away with me - until one rests trustfully in The Lord. When I am actually dying, I have no choice whatsoever but to be a dying person; no choice but to die and death is shrouded in mystery. I can’t help but wonder if I will be as trustful and serene about my dying and death at the actual time. No way of knowing and not much use at all trying to know. Trust.
A very dear friend of mine had been a lapsed Catholic but prior to death was reconciled and went to Confession and received Holy Communion, Extreme Unction, after which she lapsed into a coma. After Confession and Holy Communion her manner of dying, was marked by great Joy until she lapsed into a coma, and she had known she was dying and probably would not see Sunday and two days away. There were no moving last words, just Joy to have her friends with her and it seemed as if we were just visiting her in hospital due to her own attitude, not that we were at the bedside of a dying person. After she had actually died, it truly looked to me as if she was just sleeping and could wake at any moment. Recalling the experience, it was a nurse who told us that she had died and no longer in a coma. It was an amazing experience.