My boyfriend never wants to have sex

My boyfriend and I had a difficult sex experience a couple weeks ago, where I admittedly told him I felt very disconnected to him for the first time ever during sex. I asked him if stopping sex was something he wanted; he said no. Since that experience, we haven't had sex, and the mood is never there for him, no matter how many opportunities arise. I'm worried that now that we've stopped for a while, we won't find it again. It hurts my feelings to know he doesn't want to have sex with me; it's always where we've felt closest. Thoughts or advice? Is there anything I should say or do without forcing it upon him or sounding needy? ... Sigh 😔