Well, I'm going to disagree with everyone else. Let's turn the tables a bit and see; My OH has long hair. I find long hair sexy and do not fancy men with short hair. If he cut his hair I would be sad and disappointed. I would try to stop him and I would be honest and say I would not fancy him as much.
Shallow? Yes, of course but sexual attraction IS shallow. People are attracted to what they are attracted to. It's hard wired into us. End of story.
So I think your husbands strong reaction is understandable. Of course theoretically you should do as you like with your hair but it would be terrible to do something so drastic as a knee jerk reaction or to teach him a lesson as it were!
And the style you are thinking of is very unforgiving and can make even a pretty woman plain.
The strong reaction is unfortunate but understandable. In general straight men really HATE short hair. You gave Emma Watson as an example there. You asked you husband did he like her hair short, of course he made the required noises, it's not his wife. But given his choice it's unlikely he'd pick her over a longer haired woman.
Plus Emma Watson really severely disimproved her looks by cutting her hair. Sha had to do it for a role btw. She's still an attractive girl and it will grow back but she's nowhere near as attractive as she was.
Another point, it takes a REALLY good looking woman to even look passable with short hair. Sorry to be blunt but true. Look at Halle Berry. She's very nice but one always looks at her and thinks 'ah, what a pity if only she would sort out her hair' She would be 10 times more attractive.
Pixie haircuts are awful, I'm sorry. Sometimes people have no other choice if their hair is baby fine and will not grow but it really is a style of last resort.
Even if you have the bone structure of a supermodel a pixie haircut is difficult to wear, can't be adapted and without makeup can be quite unfeminine.
How about a compromise, maybe get some layers and shorten it a bit but keep some length?