We're not advising you to throw it away, hon, although I know it sounds like that. Instead, we are trying to tell you, based on 100's of stories like yours in this forum over the years, that it is very difficult for a LD spouse to change. We are trying to tell you that there is no magical formula to make him change, which is what you are really wanting to do. We are trying to get you to see that there is really nothing wrong with him, he is just different than you. And that you may have to accept a sexless marriage if you want to stay with him.
I'm sorry you feel discouraged. If there was a magical formula to make him change, we would share it with you immediately, as that is what everyone who comes here wants. If one was found, this board will be the first to know.
The encouragement you seek will be found in you taking good care of yourself, and not taking his rejection personally. I know that doesn't really help you, but that is truly all there is that you can do to help yourself.