I personally enjoy the flight mechanics. Ships still need more of a sense of mass, but that's difficult without making them feel too weighty. Supposedly ship components (such as the engine) will add mass, so we'll see if that dials it where it needs to be.
The inevitable comparison comes to ED's roll-to-yaw FM. I've got about 500 hours in ED, and I think I still prefer the SC FM just because some ships "feel" different than others. ED ships do have a distinctive character, but sometimes it feels forced, like the DBE and the DBS. Similar chassis, but pretty drastically different flight behavior, though it feels to me more like "one has a slower pitch" instead of "the tail likes to kick out when you punch it and turn".
That's my take. Honestly, I've been spending more time in ED as of late trying to fly a Vulture using a Samsung GearVR that I'm using as a poor-man's Oculus.
EDIT - Hit the post button before I realized I still hadn't answered the rest of your questions, give me a sec...
Do I think it's compelling when people expected it to be closer to a true sim? Not really sure what you mean by that, seems like a bit of a leading question.
If you mean that it should be more realistic, I feel like it
is pretty realistic. It's a pretty solid 3rd-order Newtonian flight model, and you can definitely feel the thrusters pushing the ship around. I bookmarked a video a little while ago that I feel like captured this pretty well (though the first minute and 45 seconds is just Cruise jousting and can be skipped):
https://www.youtube.com/watch?v=8ueC0CVwypo
I think one thing absolutely critical to the flight model though is the sound execution. If the thrusters rumble around you as the ship moves and corrects rotation or drift, it feels a lot more realistic than it would otherwise. One concern for me in SC currently is that some ships seem to have much better audio cues than others. Maybe it's just the new headphones I bought, but in that video the ship seems to have more substance than I'm used to. Or maybe it's because I'm not flying it, if that makes any sense.
A lot of people who play SC enjoy the way the Gladius handles; personally I can't stand it. It feels like you're driving a pickup on ice. I'd rather fly a 325a, though many other players would consider that a sub-standard combat ship. They both have pretty unique flight characteristics, and some people have very different preferences based upon those characteristics.
I'd be very interested in the perspective of someone who can't stand SC's flight model. I've heard some people say they hate it, but I've never really understood what the reasoning was.