In Copenhagen, Denmark the municipality is actively encouraging recreational use of the cities cemeteries. As they write "The cemetery is also for the living". Everything else seems like a waste of space imo. Respect and leisure ain't orthogonal.
spots in cemeteries are also usually only affordable for the propertied class too. for many in the working class they're not viable.
do our cities really need to reserve and block off sizable physical spaces for decades, when we have a housing crisis in most cities around the world? i am all for beautiful ceremonies and the like, but the use of excessive physical space in cities seems outdated.
consider also that we now have photos, video and other digital media to help us remember loved ones and keep them alive in our memory.
If you have an existing cemetery, at least convert it into a dual use space like the one in Boston with the fish ponds and maybe also put a playground up. There aren't nearly enough of those for parents of young children. Especially during a pandemic when you want to not cram 100 kids in a fairly small space.
"Some" are probably ignorant of the fact that cemeteries have been routinely moved in Western societies for centuries. It's not a new thing, and there are cultural procedures for doing it respectfully. It is also in a different sense a tradition to argue about who is going to pay for those procedures since they aren't the cheapest, but that's a separate matter.
So, your question can be given a concrete answer: No, we aren't stuck with cemeteries forever in the place they were plopped down decades ago. That is a present reality, not something we have to aspire to.