I’m a sexaholic, two months sober. Since you and your husband are on opposite sides of the issue, let him know you love him and are trying to help him recover, and that you do find him attractive and plan on having a life in the bedroom again and some point in the future. I don’t know him, but I know words of affirmation are important to me.
Also, sex should always be consensual. There will be times when you don’t feel like having sex for a miriad of reasons. It’s important for him to learn to process that in a healthy way.
I hope you two are able to have a productive conversation and figure it out.