We have been using a queen size air mattress with builtin pumps in all 5 of our last 5 RV's. 2 Lance TC's, 2 Carriage 5th wheels, and our Sunline Solaris TT. All have been extremely comfortable and infinitely adjustable for in flation anytime. We have inverters to run the pump for altering the air pressure when we are not on shore power. 4 of them have dual chamber controls so we can each have the firmness pressure we desire with just a touch of our chamber button.
So much warmer in winter in the TC as there's no metal springs or thick cold foam or fabric/stuffing that gets bone chilling cold and then chill the heck out of you. The air mattress doesn't at all as it's easily warmed to body temp very quickly. To add to the cold blocking status, I layed down a full 60" wide layer of Astro-Foil under the air mattress. Been doing this air mattress replacement since 1988 and will never go back to a heavy very uncomfortable fixed firmness mattress.
NONE of our 5 have ever leaked at all and one is over 20 year old and used a lot. Plus we have and had always had a Siberian Husky Dog while using the air mattresses and yes, all have jumped up on the cabover bed when we are down below. Remeber, even with a large dog up on it, no leaking air mattresses ever in our RV's. Simply lay a comforter over the air mattress and a fitted sheet over that and even the dog's nails never puncture it.
Besides, they are so much lighter in weight and also much cheaper to buy than a normal mattress. So replacement costs if ever punctured is real cheap anyway. For years, we carried an extra new air mattress with us but never had to use it so we use it to replace the OEM Beauty Rest mattress in one of the RV's. Also of note is that even if you need a replacemt, they are sold all over the USA in Walmarts, Targets, Meijer, Bed Bath and Beyond, and dozens of more stores and is why we don't carry an extra anymore.
My wife is disabled and never found any mattress that she is comfortable on other than the adjustable air mattress. Something to remember about Memory Foam Toppers is that when they get cold they get very hard and they hold the cold a very long tiime and why we don't use them in the TC. We do have a 2' memory foam topper in the Carriage Carrilite 5th wheel on top of the air mattress as it gets heated under the bed because there's a 4" X 12" vent on each side of the bed riser and also, the air mattress is so much lighter to lift the bed to get at stuff stored under it.
Simply put, the air mattresses are fabulous and a win win win and have never had a single complaint about them.
BTW, we had a Sleep Number bed at home and replaced it with a duap control air mattress also and it's much better than the outragously expensive overpriced and very heavy Sleep Number Bed for both of us.
The OP must decide for himself!