Both my parents and grand parents (one from each side) died knowing I was an atheist. But they had 50 and 15 years (respectively) to let it sink in. And they all died a lingering death with their minds going before the body. I doubt it caused them much grief.
Being told you're delusional does not necessarily mean you're mental.