I also don't want one, but if someone said "I hope there's a heaven so that he will have gone to it" after I'm dead I wouldn't call that disrespectful in the slightest.