The 'Thorn' was not about his sexuality.
It is plain by the text and context that he was speaking of something else. First he tells them about 'a man' (most likely himself) who went to heaven and saw things there he wouldn't speak of (quite the opposite of what John did in Revelation). To these things he was trying to stay humble and it seems apparent by the text that he was having a hard time doing so (he mentions that it was 14 years ago).
1 2 3 4 5 6
In verse 5 he mentions his infirmities--
5 Of such an one will I glory: yet of myself I will not glory, but in mine infirmities.
It really should be rendered as 'my weakness' as the following confirms this.
7 And lest I should be exalted above measure through the abundance of the revelations, there was given to me a thorn in the flesh, the messenger of Satan to buffet me, lest I should be exalted above measure.
IN other words,
So I should not become conceited from my receiving these revelations that were exceedingly superior to all others I was given a thorn in my flesh from a angel of Satan to keep me from becoming too conceited.
8 For this thing I besought the Lord thrice, that it might depart from me. 9 And he said unto me, My grace is sufficient for thee: for my strength is made perfect in weakness. Most gladly therefore will I rather glory in my infirmities, that the power of Christ may rest upon me. 10 Therefore I take pleasure in infirmities, in reproaches, in necessities, in persecutions, in distresses for Christ's sake: for when I am weak, then am I strong.
It is clear that this 'thorn' was meant to keep him humble and not to think of himself as better than other from what he had been chosen to see. So after asking three times and basically being told 'no' because he needed it to be there in order to do the Lords will he then says he glories in that infirmity.
7 And lest I should be exalted above measure through the abundance of the revelations, there was given to me a thorn in the flesh, the messenger of Satan to buffet me, lest I should be exalted above measure.
The word used there 'to buffet' actually means to smack down, to put in one's place.