Pain caused by deep penetration can be related to a range of issues: tilted uterus, endometriosis, bowel problems, interstitial cystitis, cysts, fibroids, scar tissue, shortened vagina, hysterectomy i.e.
Some women experience such an intense pain that they no longer want sex with penetration. This is quite natural and very understandable. Sex can be fun and giving without it. If you don’t have a satisfying alternative, you may find inspiration in The Love Bit. Read Penetration has no veto power and Stimulation & Sensation
Others can not imaging a sex life without penetration. They miss the feeling of being that close to a partner, to feel him inside, or they just do not think sex is meaningful without penetration. If you experience a longing, you might benefit from reading The Elephant in the Room