I faced a similar dilemma age 41.
I wasn't the least bit maternal. If I am completely honest, I found small children irritating, even my neices and nephews.
I married at age 38. My husband and I decided together we wouldn't have children. I felt completely at ease with that decision.
When i discovered i was pregnant, after the initial shock, i was at best, ambivalent about the situation. What gave me pause, was that i believed it would be my first and possibly last pregnancy.
I needed to decide if i wanted a baby now or possibly never.
If i had been younger, i would have terminated. No question about it.
But once my pregnancy was confirmed, my husband and i decided to proceed. I'm glad that we were both on the same page, because once i had our daughter, all hell broke loose.
My baby did not sleep for 6 months. I felt like i was going out of my mind, hallucinating from lack of sleep and arguing constantly with my DH, when never a cross word had passed between us.
At the time i was feeling angry and resentful. Having a baby felt like a big mistake.
We'd both reached breaking point when 2 things happened: my husband and I had a long, honest conversation and agreed, going forward, we would be a team, supporting each other, and commited to the family we had created.
I had a bit of an epiphany where i decided that i could continue to be angry and resentful, hating my new life, or i could embrace it. It meant letting go of my desire to have my old life back, and whole-heartedly embracing a new family dynamic.
Anyhow, things improved a lot. Our baby settled, and i went back to work, swapping primary care with my husband. We had a second child 18 months later, and shared the primary care.
Fast forward to the present, our children are 9 and 7 and we both work 4 day weeks, continuing to share the parenting and domestic load.
Family life is a lot of fun. It can be intense and chaotic. We are perpetually tired. Our finances have taken a hit. But we are all happy and thriving.
OP, only you can decide what is best for you.
Parenting in the early years is really, really hard, but i don't regret it.
I wish you luck going forward with your decision.