Attempted sex after 2+months(now33weeks), bummed

Before baby we had sex almost every day. Had my last period the last week of April and then had sex May 4th our 3 year anniversary, this was the date of conception. I know this because from that date on my body was just not feeling sex so we didn't have sex again for almost a month and found out I was pregnant 2 weeks later and was 6 weeks.. ANY WAY

Since becoming pregnant my body has just been like : sex ? Absolutely not. Even though my brain still craves it. So we've only had sex about 10 times total, and the last one was 2 months ago. Again my brain wants it so bad so I've really really been trying to make my body cooperate and we finally attempted it again last night. Y'all I'm so bummed . It was uncomfortable start to finish. No matter how much lubricant i felt dry, no matter how slow or fast it felt like sandpaper. My belly felt like the skin was going to tear, my hips felt like they were splitting :( I did not have the heart to stop it because he was enjoying it, and I feel so guilty that we went from 20+times a month to once every couple weeks then none for 2 months:( I miss my bodily sex drive and being comfortable . I really don't think we will be attempting again until after my postpartum recovery :( one of the things I'm looking forward to most about having this baby is my non pregnancy sex. I really feel like not being able to have the kind of release through sex that I used to, that I'm suffering emotionally. Anyone else just really wish sex was easier and more comfortable while pregnant. He fell asleep right after but I'm not sure if when we go to talk about it tomorrow that I can tell him it sucked for me :( I feel so bad :( I really wanted to enjoy it. :(