husband doesn't fancy me

My husband is lovely, kind and affectionate. He's full of hugs and kisses and says he still fancies me. He just doesn't fancy my body in a sexual way and can't find it arousing. I know logically this makes sense - some men don't find the sight physically attractive - and I don't want him to begrudgingly have sex with me! Is anyone else in the same position?