When will this go away??

29 weeks tomorrow and sex has just been so uncomfortable. I know I dont have any sort of infection or anything bc I was just at the doctor on tuesday.

It's a little Tmi but my husband and I will start to go at it and when he goes to stick it in, it feels like a sharp stabbing pain. I've seen so many other pregnant mommas post about this usually around the same weeks I am now. Does this ever go away? It doesnt help when my hormones are off the wall and I want sex all the time but it's not worth the pain. Any advice or time frame of when this will stop?