To me it does sound unpleasant, like out of tune in a bad way (and I love untuned, atonal, experimental electronic music and use my own modular synth often, as a point of reference). Like the OP, I never understood the appeal of a theremin.