TIFU by saying someone was hot to my boyfriend

I want to start off by, yes, this was entirely my fault. I also want to note that I have autism, so I have extreme difficultly with communication and social appropriate things to say, I wish I could go back and fix it. I'm texting my boyfriend about a movie I watched last night while he was having a party out with his friends. We were watching Oujia with our neighbors in our resident hall.

Fast forward to now, the very next day I noticed he posted his story of the same movie and the same priest. The thing about me and my boyfriend is that we always talk about how cool priests are, we're both considering christianity, but that aside he really wants to become a priest. In my head, I thought this: "What a perfect way to converse, I'll just bring up the movie, talk about the priest, we can laugh, I can flirt with my boyfriend, show him my love and how we're literal soul mates for watching the same movie without telling each other." It was indeed not the perfect plan, I started off by talking about the priest, I said he was bad (as in badass), he got confused, asking "bad?" And I replied with "Hot, but I'd choose you any time over him."

It didn't compute to me that what I said was wrong until he felt hurt. I was confused at first, as any autistic person does when they accidentally say something wrong. I was speechless. I quickly reply with "ok sry", (I use the short text terms when I'm confused or embarrassed), he took it as "I do not care" which only escalated his unhappiness. I felt awful, I even start to cry a little because I really didn't mean for this. I apologize a lot, I understood that I was completely out of line.

I made him feel inferior. He's the best thing that happened to me and it was a genuine mistake. My boyfriend struggles with severe body images, and anxiety, whenever we have a complication, he always violently shakes, but of course we always talk it out. Despite my awful lack of emotional intelligence, I'm good at trying to mediate his emotions. I really only wanted to have a fun light hearted chat, since he occasionally, but very rarely will talk about his fictional crushes, while I hardly have any since I only have eyes for him. I just feel awful. I made him sad, and now I'm sad, he's sad, what if he does something to himself? I wish I was smarter.

TL;DR I call someone hot to try and have a conversation, he gets very unhappy. I make it worse with miscommunicated confusion, leading to him getting angry. I try to reassure him I only tried to make a joke and I don't actually find him hot, but I worry he will hurt himself.