So... I think what you're really wondering, OP, is how "normal" your situation is...
I guess the answer to that is nobody really knows as different people do different things...
However, it's understandable you may crave some sort of affirmation. When people compliment us it's not just about them saying "you're gorgeous" and only being able to believe that if they say it. It's actually about the fact that they've noticed you. It's a sign of caring about how you feel.
I'm sure if he complimented you in other ways like "you're so funny" or "you really sound beautiful when you sing" you feel just as sexy and wanted and cherished.
I really honestly do feel compliments are important. Teachers use compliments to motivate and reward good behaviour in students, don't they? A simple "what a great drawing!" is enough to make a child's eyes light up.
But do remember that self esteem has the word "self" in it. I think we can feel good about ourselves even without compliments, if we do some things to nurture our own needs etc.
I guess I'm saying I think we humans need both "self" esteem, and "other people" esteem to feel thoroughly good.
In my case, I still compliment my husband but he rarely does compliment me anymore. And if he'd always been like that I might not feel so bad, but the fact that he used to wax lyrical about me and now doesn't feel inspired to do so anymore, suggests he either takes my presence or feelings for granted, or he just doesn't find me attractive anymore (I'm older and fatter!)...
So I completely relate to you feeling undesired and unimportant.
Can I suggest you start doing some kind things for yourself, and also tell your husband you feel a bit sad and you'd love a little compliment from time to time. I agree men deserve them too, so throw some his way if you don't already.
I hope you have a lovely day.