I think it’s best to keep things short and honest. He would fair better with a partner that is similar to him and is ok not having sex. There are women who want a man like him and don’t want sex.
You need to free yourself to find a partner that you can enjoy a sexual relationship with.