I suppose I can speak from your husband's point of view. I don't know if you can ever overcome that sense of being off balance around something that makes you uneasy. So, if it's possible maybe don't rush the decision, another home with another less disturbing reason to be affordable may come along.
To me, it sounds delightful you are moving to your home town.Use all the old contacts you can to find out what may be coming up for sale.
Speaking of cemeteries and real estate. There is a funeral in my hometown today. My beloved old Sunday School/ Scripture teacher died on Friday. What an incredible woman she was. I can't go today
although my o my , I feel like jumping in the car right now and zooming up there.) There is much speculation, which I find very distasteful, about what will become of her house and land. Real estate prices went crazy in the town that I grew up in, absolute and utter madness it seems to me. I will never be able to afford to live there again
So I understand why you are considering this place.
But I think even though you may feel at ease, ultimately your husband has to be able to feel at ease too.
I have friends who live, as it turns out, in a cemetery and they are happy and at ease there.
Good luck.