I'm a practicing Catholic (most Sundays) and I attend one of those "mega churches" on an occasional but consistent basis.
However, I have never had a belief in an anthropomorphic God or spiritual higher power.
I agree with Christ's teachings of "on earth as it is in heaven" - meaning our heaven can/should/only is found right here and now.
So, I'm pretty sure that when I die, the lights go out, my cognitive processes stop and I cease to exit for all eternity. But for a flicker of a memory in other people - nothing about me remains.
I will not be "seeing" God, nor loved ones, nor white lights etc. This sometimes gives me pause - but mostly makes more spiritual, more present. Which, I believe, is the core and lasting (eternal) idea of Christ's teaching.