If you are no longer enjoying the spanking and it is inferring with you being able to obtain an erection.... then I would talk to your wife about this matter.

May I ask? - are you enjoying this female domination or would you like it to change and you be more in charge?