I asked him to be friends with benefits, and he got mad, why?

I’ve had a friend at work for 8 years. He flirted with me when we first became friends, and I shut it down back then. He is 54, I’m 44. Everything was fine, until recently when I’ve started to like him as a little more than a friend. Last week, he asked me if I ever wanted to hang out in our spare time and I said I would like to, but only for sex.
He got mad and said that we weren’t looking for the same thing, he doesn’t want to live with anybody… then ended the conversation. I am so confused. I am even more confused about how he got things so confused. I only want a temporary fling. I thought he would be happy, but it seems to have ruined our friendship. Please share any insight, advice, or similar experience. Thank you🙏

I asked him to be friends with benefits, and he got mad, why?
Post Opinion