Presumably it's oblivion, so there's nothing to be afraid of. Just as you weren't afraid before you were born.
What scares me is if I'm wrong on that, because if there's some type of afterlife where we're penalized or forced to reexamine ourselves or whatever, that would suck. It's quite a popular thing now to believe in reincarnation with a whole body/life selection process, along with lessons to learn, ongoing karmic issues, amnesia at birth etc.
And that's a belief system in a millenial world where everything's softer and more tolerable and nobody's yelling at you - it could of course be far worse.
It's weird, because a person comes off as naive if they believe in any of that, yet if we're wrong and there is this whole shebang after death where things are far from rosy, then that's quite the price to pay.
That's what makes me hesitant to leave this life, not there being nothing after this. Looking back on the last 15/20 years, I'd have been objectively better off shaking off this mortal coil all those years ago. With the caveat that there really is oblivion, of course.