I am like your husband. Star Tours, no problem. Cannot do Body Wars. We were there last week and rode Mission: Space on 7-3 and then again on 7-4.
I had no problems the first time. The second time I was a little queasy but it went away in about 5 minutes. I think one of the keys is to listen to them when they say look only straight ahead.
My husband has vertigo and usually has all kinds of problems. Could barely stand after Primeval Whirl. He had no problems with Mission:Space.