There are two parts to sex (and I don't mean the clit and the g-spot...) -- physical and emotional.
Women have few nerve endings in the vagina itself -- so simple 'insertion' doesn't do anything. (If it did, we'd all get turned on having speculum exams at the doctor...). And is why most women, when they masturbate don't bother with dildos and insertable vibrators -- whatever the teen-boy trolls might think. Most physical sensation IS external -- with, for most women, some pleasure from friction and movement and pressure that stimulates what nerves (internal and external) there are.
Some women also find that once they have had an orgasm, they just arent' into any kind of sex. So if he is taking care of you first, and you are satisfied, intercourse may be kind of boring for you.
The other part of sex is emotional. If we are close to our partner, emotionally, it gives us pleasure to know that THEY are enjoying themselves. (Even if we are a little bored by then...)
If vaginal intercourse is truly unpleasant (and there is no obvious physical cause like him being too rough, or you are too dry) I would be thinking about your emotional relationship. Do you care about him? And him about you? Are you having sex because YOU want to, or because you feel you're supposed to, or he's pressuring you?
If you feel a genuine closeness to your partner and that isn't enough -- then either agree to focus on activities other than intercourse -- or be sure that he is stimulating you in ways that DO give you pleasure, both before, during and after. (If you can't enjoy sex after orgasm, then try having him stimulate and arouse you but NOT to orgasm before intercourse. Then, if (as is true of most women) you can't orgasm 'during' -- he can take care of you afterwards.