I have had that exact same horribly painful experience every single time I've had sex. I don't know why it is, but once it's in all the way it stops hurting after a while. It's so weird and it makes no sense. I wish I had answers, but I don't; just want you to know I can definitely relate.