Your husband sounds like me. I can make it through Star Tours, but I don't want to. Body Wars -- NEVER AGAIN! I say the same thing about Back to the Future -- NEVER AGAIN! It was just awful! However, Spiderman is wonderful, because you actually move! (I think it is the best ride in Disney and Universal.) Cat in the Hat, no problem. Men In Black, no problem. Jimmy Neutron, I haven't been on, but if it is anything like the previous ride there, your husband should be OK.
On another topic, I really wanted to try Mission Space, so I took some motion sickness medicine before I went. I got slightly sweaty by the end of the ride, but not bad at all. I don't think the medicine had time to take effect because later on that day I just ZONKED out (slept through the entire ride of Ellen's Energy Adventure.) I think I'm going to try mission space again without medicine and see what happens. (The liftoff was fine, it was the asteroids that got me sweating a little.)
Katherine