I've been sleeping on air mattresses for years now. I wouldn't use anything else but. You can inflate or deflate them to your comfort level which for me can vary daily. You can't do that with a traditional matteress.
I've always gone to the camping dept to locate a matterss. I have one that sits a minimum of 18 inches off the floor so it's at the same height as a regular bed. I even get the kind where you can put sheets on it and they actually stay on.
I had one when I was married too and we never had to "take it to the floor". I even have a twin sized one set up as a day bed in the living room. If you want the link to the one I use lemme know!