There's a few details you left out which would help - like - has this always happened at this "time" or is this only recent? Your age? Are you having intercourse with someone other than your usual partner?

Possible causes could be:

guilt (going behind a parents back, cheating on partner, or even just the fact that you're getting pleasure from sex - unlikely if this is recent rather than a long term issue);

age & hormonal changes could cause migraines (which is what you seem to be describing);

if this started when you first started sex & orgasms then again I think of hormonal issues which often cause women to have migraines.

Religion? Some religions teach that women should not enjoy sex so therefore if you enjoy it you may feel guilt & so "punish" yourself with a migraine.

Just some thoughts based on the very little information you gave.

When you have an orgasm, a lot of blood rushes to that certain part of your body. Some people get light headed, you probably get a headache from more blood being lower than usual. I wouldn't worry too much about it, but if it gets any worse or is too bothersome, definately go to the doctor and see what they have to say.
At least you can reach orgasm!!!!!