Worst thing you can do is be less affectionate. If you love him be more affectionate.
Ask yourself these questions (no need to answer here):
1. What is your definition of sex? Anything sexual or intercourse?
2. Did you ever enjoy sex?
3. Is your husband a good lover?
4. Did you ever have a traumatic sexual event?
Not wanting sex from someone you love has a physical, psychological root or both. If you think it is physical, get medical advice. If you thing it's got a psychological, consider seeing a therapist.
My story:
I've known my wife for almost 35 years. She had been sexually active for almost 10 years before I met her and never had an orgasm. The first time we made love she orgasmed non stop for a long time. We had sex all the time. She tried out things that she had thought about but never done. Very positive situation. ...Then she would have problems were iud and bladder infections, negative reinforcement. .. slowed things down. About 7 years into our relationship our young son started having behavioral problems in preschool and kindergarten. She had him see a therapist and went into therapy herself. This led to recovered memories of sexual abuse at very young age. Sex over the next 25 years was infrequent. We would make love and she would orgasm
almost non stop until every bit of sexual tension was gone from her body (1 hour ). She is a great lover. I have a very high sex drive and would make love every day. You would think that after such a pleasant experience she would want to make love again soon, but that wan't the case. Sometimes the result of sex was another bladder infection...negative reinforcement.
She talked to her gynecologist about this and was told that we weren't doing wrong only that it is a result of infrequent sex.
We love each other very much, are very affectionate and touch and carress each other (non sexually overt) and hold each other when sleeping. At times she says how much he enjoyed my penis. I say to myself then why didn't you take advantage of it over the years. Nothing I can say or do is going to change things. It is what it is.