In fact, I think there was a lot of useful info there. Things that you can learn from and use for the next time. For instance, what was stopping you from saying, "I'm getting overly sensitive, can we switch to oral for a while?" I know he would have jumped at it! From my standpoint, it appears that you were/are trying to appease him too much, to the detriment of your own experience. And that feeling is what caused the emotions to well up afterwards. The feeling that you are doing it all for him and, then last night it WAS all for him, dammit!
If the hormones have plagued you in this way for your whole marriage, then chances are he is familiar with you saying that sometimes it just isn't going to happen from manual stimulation. Let him know that, at those times, you are totally open to trying something different.
Also was it (your clit) getting dry? Sometimes just a little lube or my natural wetness will get the good feelings going again, even though it is basically the same motions. Or, you could have him just stop with the stimulation for a time until you are dying for him to touch you again and he can restart. Or, you could purchase a vibrator just for this position (I know that I have a hard time coming from this position and I have no idea why! It is really pleasant but something about not being able to spread my legs really impairs my ability to have an orgasm this way). Ok, that's all the suggestions I have for now.
My point is to NOT let this get you down and if the opportunity arises maybe you can discuss this with your H...why you didn't stop him at the time and what you two can do differently as a couple to work around these hormonal blips.
GOOD LUCK! And don't worry about it at all; you'll find some way around it.
