sex while pregnant!

I'm 29 weeks and we never really had sex since I've been pregnant because it hurts & extremely uncomfortable, So tonight we got a hotel room he made it all cute the roses and warm bath. I wanted to just eat him up lol I was turned on and everything but once we started I instantly tensed up because of the pain 😢😢 it was painful  but I didnt want to stop because I felt bad for him but I seriously had to tho because it was horrible we havent had sex because of this is this normal during pregnancy?? It feels like it's extremely tight down there and it's even hard to actually get his penis in. 😩😩