If there’s no afterlife, there’s nothing to be afraid of.
Eternal oblivion scares me. It’s scared me to the point where I’ve dreaded going to sleep at night.
If there’s no afterlife, you won’t be aware of eternal oblivion. You’ll just cease to be. Nothing to fear.