Heavyheart, bear in mind that your partner can appreciate the holy heck out of you and still not want to bed you. We've addressed this subject somewhere here on the board. Men and women both sometimes think that if I do all the chores, smell good all the time, take care of the kids, cars, lawn, home repairs, decorating... whatever... that my partner will APPRECIATE me and that appreciation will translate into sex. Alas, it does not seem to work that way, from either direction.
Appreciation and desire seem to come out of two different places.