It’s a kind of value debate that has no definitive answer anyway. I am personally on the side that once dead, the corpse is just a stack of decaying meat which doesn’t command respect in itself. So it’s really a function of respect to the livings to whom the deceased meant something. And this wanes fairly quickly. Perhaps a century or two for a random quidam. Perhaps a few centuries for someone illustrious. But I am not religious either.
But a more accurate comparison would be the elite, they get interred in family crypts or under church halls for hundreds of years (or indefinitely, maybe if there's a major religious or political revolution will they get removed, destroyed, or forgotten).
The modern-day cathedrals and mausoleums may end up being the pyramids of future generations. like, 4-5000 year future generations. I'm sure they'll survive the nuclear apocalypse.
The one that looks like it has been designed to resist nuclear apocalypse is Lenin's mausoleum. I know I'll be dead anyway, but still, the thought that all that will be left of our civilisation is the remains of that "great ruler"...