Help… potential TMI/over share..

So my husband and I have been together for 13yrs. We had a daughter in 2017 who’s 6, got married in 2021.. and now we’re pregnant with baby #3(we miscarried a son in 2013). Sex has always been a big thing between us, it’s always been super explosive off the charts amazing, even when every other thing in our relationship was bad, that always remained. He’s a very generous lover. When I got pregnant with our daughter we weren’t technically ‘together’ he questioned her paternity and even asked for a test when I asked him what I could do to convince him, and I readily agreed bc I’ve never been unfaithful. We ended up not having one, she came out looking like his bopsy twin, but I was willing to put his mind at ease. So our relationship was rocky during my pregnancy, we only had sex maybe a handful of times from when I found out I was pregnant until our daughter was over a year old. We focused on us, our relationship, our family, being intimate in different ways. Once we started actively trying to reclaim that aspect of our relationship we ran into some hardships, after tons of talks, failed sexual encounters, tons of frustration, and my self confidence and body image being damaged almost to the point of no return, we discovered he had low testosterone… a few injections later and a cpl prescriptions we were in business. Despite our daughter co-sleeping we’ve managed to have a very healthy sex life, we’ve had sex 3-4-5 times a week since 2018. I lost my Mom Jan 8, and exactly 4 wks later I took a test to prove myself right that stress/grief/depression were messing with my very regular cycle… only to discover I was pregnant. With a midlife unexpected baby. Today is my birthday and I’m 37, he will be 42 next month, and another child just wasn’t something we wanted. Now with my daughter I LOVED being pregnant despite vomiting around the clock almkst the whole pregnancy, I didn’t have nausea I would just get this little belly jump and that signaled me to get to the nearest trash can/toilet. I felt like a woman, my body was finally doing what it was meant to, I felt sexy, and beautiful, and although my hormones were raging and I was horny I didn’t push him for sex bc I understood and respected that we had a lot to work on. Irregardless of assurances from me and our OB he just never came around to the idea of having sex while I was pregnant. This time around however I’m having MAJOR issues with it. I’m super nauseous (no vomiting), I’m already showing, I’m exhausted with zero energy/motivation, I’m having ridiculous mood swings, I miss my Mom, we’re both struggling to accept this is our reality, my whole world has been rocked and is in flux and the one thing that keeps me grounded/connected/and is a huge stress reliever endorphin releaser is now becoming an issue, and quickly. He doesn’t want to have sex with me, foreplay isn’t an issue, using his fingers doesn’t seem to be a problem, but when it comes to actual intercourse, nope. We’ve already had several discussions about this and I already let him off the hook of our normal 3+ a week, and told him I could deal with 1 of his nights off, and 1 day while our daughter is at school. And that’s a sacrifice for me bc my hormones are going insane and I could gladly have sex daily. I just don’t know what to do? I’m not ignoring his concerns, but they’re completely unfounded. It hurts, I’ve already compromised, bc I understand and respect his concern and hesitation, but what about what I want and how I feel? I know hormones can make you irrational, am I being irrational? HEEEELLLPPPP 😵‍💫😩