I couldn't have said it more succinctly.
As great as the iPad is as a piece of hardware and software, the fact that it's a closed down, locked down, "hold the user hostage", "treat the user like minor" type of device makes it utterly uninteresting to me and many others I know.
In short, as you put it: we wanted a small mac, even a small Mac with a touch interface, but we got an iPad/iPhone like appliance, that locks us out and tells us what we're allowed to do with it.
I have better ways to waste my hard earned money.
Even though a bit clumsier, for the same money I can make a dual-core, quad-thread NetBook Hackintosh with 640GB disk drive and 8GB RAM. Not as sexy, but a lot more useful, even more useful than a MacBook Air, which with its RAM and HD limits is rather crippled.
It's not thin-ness that matters, but compact size. We live in three dimensions, and Jobs focuses only on how to reduce one of them.
In short, I'm not surprised by these survey results, and I hope that sales for the device will be disappointing and force Apple to rethink its policies. Since Apple is doing well, Jobs goes back to the same evil closed-box policies that got him fired from Apple the first time around.
Only the downfall forced him to open the system up by basing NeXT's OS and lots of tools on open source and open standards. And for a while he was preaching that as a benefit of Mac OS X. Now he closes the doors again, and if the iPad becomes a success, you can bet that the iPads will get bigger, start to have keyboards, and eventually will replace the Mac, just like the Mac replaced the Apple II.
Result: if users don't revolt now, in five or ten years you'll be permanently locked out of your device. The Jailbreaking will only work for a while, and sooner or later the holes will be plugged, and the fun is over.
Think about it, and send relevant feedback to Apple. Maybe it's not too late to make them see the light, although chances are, it's hard to revert greed once it takes hold...