As I said before, I had a termination, and I have not regretted it. Some people do (and I think perhaps this is more common if you feel rushed into a decision, so please do take your time; also if you feel unsupported in a choice by your partner) but the majority of people do not feel regret. The only regret I truly feel is that I was in the position in the first place - I regret the accidental pregnancy, not the termination. I made my choice on the facts I had available to me at the time, and that is all anyone can do. If you can get to a point where you feel OK within yourself that you made a choice based on good reasons, you won't regret it.
I have 2 DC now, and live hundreds of miles from both mine and my DHs family. It is harder than having supportive relatives on the doorstep, of course, but it's not impossible or insurmountable and actually there can be benefits - going to visit the various grandparents and cousins is an event, much looked forward to, like a holiday, for my DC. It's not how I grew up, but it's been fine. We've made friends with people in the same boat, we've found lovely childcare where the DC have made loving relationships, it's been OK.
^I'm scared if I terminate I'll regret it for the rest of my life. What if I never forgive myself and can't have a child in the future?
I'm scared that if we continue with the pregnancy the stress will destroy our relationship. I'm scared that I am in no position to be a good mother at this time.^
These are all valid things to worry about. A pros and cons list will really help you see the woods for the trees.
Is your relationship in a good place (if you are worried about this affecting it, I mean)? You are married, this is a challenge to how you thought life would go in the near future but it should be the sort of thing you can overcome and support each other through.
No one (no matter how sorted, or how longed-for the baby is) is sure they'll be a good mother. It's a scary business. But unless you have real financial or mental health pressures, say, then the chances are really good that you'd be a fine mother.
More
for you.