The Jamie Lee Curtis look doesn't do it for me. There's an example of someone that makes it very unattractive. That long face, and she's just borderline attractive to begin with (in her younger days - I realize she's just old now).
Then add in the pixie haircut, there's almost no sexiness at all to it. It screams masculine lesbian.
Then someone like Emma Watson has pulled it off in the past. And I don't have some Emma Watson obsession or something. But she definitely still came across as attractive wearing the pixie hair cut.
It's never going to be any guy's first preference, but some girls can pull it off quite well.
My girlfriend is one too, when she had one years ago. But hey, I got to say that.