The height isn't that bad but it's enough. I wouldn't say that your husband shouldn't go on it. I wasn't sick afterwards, just tense and nervous during the "ride". After that, I felt fine and wanted to go on it again. It is a great experience and my second time (in the second row) was much better.
Yeah, you do go up off the ground and have nothing under your feet. You are on a bench seat with hand holds if that helps. As someone who, I think, has the same fears as your husband, I would say he should try it but know what goes on. If he opts out once he sees the layout, he can. That's the important thing - he can walk out without riding if he wants. Won't harm a thing.