That is called en.wikipedia.org/wiki/Orthostatic_hypotension

I have never experienced it in connection with sex, but I have experienced it a lot by itself. People like me, who have naturally low blood pressure, are more prone to orthostatic hypotension. But even people whose blood pressure is not low at baseline can experience such dizzy spells.