It's not fainting from pain, it's a vasovagal reaction, the same thing that happens to some people when they stand up too fast.
I would categorize the pain from her sounding my uterus to be less severe than my typically painful period cramps.