Has anyone else come to the conclusion that OP might also be a little on the ASD spectrum? I didn't even really consider foot fetish until I read the comments.

Compared to others, autistics are way more likely to upset people in social situations due to simply not reading the room accurately, not dropping a subject, accidentally crossing boundaries, etc. Either way your friend's response is out of your control OP, I'd suggest getting therapy and put the work into learning how to love yourself so you don't want to jump from a balcony from the sheer pain of the rejection.

Also IBS sufferers here, the gut pain part is too real. Eating a little better, taking probiotics and improving mental state have a huge effect on gut pain.