I have had some luck with this… but it's really awkward after.
My mate and I were a bit drunk and he started talking about what it would be like etc.
He ended up fucking me which was a bit further than I planned so be careful what you wish for!
We are still mates, but it's a bit strained. . .
Sounds like you regret you did it. But he fucked you and that´s something most gay guys wish they could do with their straight friend at least once (I wish that a lot especially with my one straight friend). It would absolutely be worth the awkward moments after but not worth to lose a friend (though he is not my best friend by any means).