The haunting traditionally occurs when the dead person's grave is disturbed and their rest interrupted.
So it's not the fact that they're dead and buried in a place that makes it haunted, it's whether the grave has been interfered with. They don't like it.
This doesn't worry the archaeologists. Or does it? We should ask.
I grew up living a few metres away from a graveyard. There'd been a church on that site since the 10thC. And it was an unusually large graveyard in fact, now I think of it, the largest non municipal one I know.
As a kid, one favourite pastime was to go and chat to the gravedigger as he worked (in the days before JCBs digging the holes). And he'd often find grave furniture, bones, gold rings etc, or so he told us. People less squeamish in the 1960s so they'd frequently leave the dug up bones scattered around the roses (now the rose beds are all long gone due to being high maintenance I guess). When my husband, who lived in the Midlands, came up to see me there around 1980, I took him to the graveyard to show him the entire skulls, finger bones, teeth, etc... Also can remember an entire section of Victorian graves vanishing overnight and now the most recent burials are there.
But they have now moved on to a new part of the graveyard. Where the 1930s/40s unmarked graves are. How do I know they're the 1930s/40s unmarked burials? My grandparents were there. No longer. They've been grubbed up. (Vicar assuming no-one left locally who knows where the bodies are, quite literally). I went there one day last year to mum's grave and realised where my grandps had been, near a yew tree, now a brand new grave... The ones with stones have been left - for now. But I guess they're next. Precise burial records for that part of the graveyard were lost in the War. So I think the vicar was capitalising on the fact and assumed with no records and barely anyone left alive from the 1930s... My grandma died in 1939 and grandad in the mid 50s. I couldn't see any obvious bones, but I think people are more squeamish these days so those things are probably binned or summat. (Imagine hoiw many ghosts might live in the church rubbish bin).
I always wondered what happened to those great 19thC gravestones. As I say, we lived metres away and my bedroom window looked out over the graveyard but I never saw the old stones being removed. But recently, mystery solved when I got chatting to an old farmer who does maintenance in the churchyard and he told me him and his dad were contracted to grub them all up one day (presumably I was at school so never saw it). They were told to leave one or two which had known descendants in the village. He said they were all piled against a wall or something but I've never seen em...
Basically, your tenure of a churchyard grave may be 100 years if you're lucky! Then you're quietly grubbed up and replaced.
There's 1000 years' worth of ghosts on that hill near my old house, I reckon.
I do a lot of research in local parish records and for some villages have spent years studying them. You get to know and love all the old family names, that crop up over and over. Village near here, about the same size as your's, has maybe 50 or less 19thC gravestones in the churchyard. Oddly, almost every single one is an unrecognisable to me surname, even though I know those records well. People who were maybe only there for a generation so maybe crop up in one marriage record and one or two burials. So, unmemorable, in terms of the old farming families who predominated. Others, have been there since the first page of the parish records and many of them had many kids and many generations lived and died there but not a single gravestone extant for that name. Not one. I've realised the stones you see in graveyards tell you almost nothing about who once lived in a place. Or even everything about wo could afford a stone as many no doubt had them but then got shifted.
ETA: My late friend asked to be buried in one of those green burial sites where they put a tree over you and the place will slowly revert to woodland. She told me it cost 500 quid and your family 'own' that plot in perpetuity so no grubbing up.
I think churches keep quiet about it but that has always been the reality. It's why you hatrdly see any 17thC or 18thC stones in graveyards - not cos they perished but because they were grubbed up, and turned upside down for paving stones or summat...