When we purchased our RV (used), the first thing out the door was the mattress. We got an air mattress, but that didn't last very long. Developed a slow leak over night, so we'd wake up on the board. Was not used more than a few times, but over a year, so warranty was expired. DH then got a sleep number, because I have serious back problems. The first few times I slept on it, I hated it. I didn't have the heart to say a word, because of what the thing cost. But... after I slept on it a few times, it's now GREAT.
With you being on a trip, perhaps a good memory foam topper would get you through until you get home and can decide what you want to do.