Advice for someone on the ace spectrum (probably) dating an allosexual

So, I’ve been doing some reading and I think I might be grey-sexual, like so far I can relate to what those with similar experiences and my condition makes sense. I’m in a 2 year old relationship with my bf and we love each other a lot but our sexual relationship has always been a sensitive topic. Long story short: We’ve done stuff virtually and physically, I enjoy it but I never feel the need or want to initiate it. My partner is very emotionally attuned to me and unless he feels that I really desire him he does not get turned on, so me almost never wanting/needing sexual intimacy obviously this is an issue. We had an open talk recently and he was really upset because he thinks I’m not attracted to him, that he really misses not having an intimate relationship with me and that this might be hindering our emotional connection with each other. I told I might possible be ace. He says he’s ready to support me and I need to tell him ways on how we can cope with this.

He also suggested he could try being physical with other people and that this would be strictly physical. Tried this briefly in the past, and it really really sucked. He ended up getting physically close to someone, who according to him was the best pleasure he’s had in his life (it was virtual) and he wishes we had that sort of sexual relationship. It really fucking hurts when I listen to that because I’m not able to do that for him, obvs I’ve communicated that to him but it’s really just how he feels. He’s the love of my life and he’s so good to me and I know he’ll be supportive of me but i can’t just ask him to ignore his sexual needs. I’m scared I’ll lose him if he develop emotional feelings for someone else but also scared I might lose him anyway if I’m not fulfilling his needs. I really really dont wany that. Realistically, what should I do? People whove been in similar situations, how have you dealt with it? What can i do? please help me.