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"...
1. The manner in which it is done and your motive. E.g. Are you taking care to preserve the grave and the buried? Are you primarily looking for things which has a monetary value? And what are potential descendants saying about you doing it?
2. The time which has passed. E.g. If it has become "forgotten" and not taken care of regularly it could maybe be seen more as a historic site rather than a grave.