There is no easy answer to this, and it is so individual. I also frequent a popup trailer forum, and many people there complain they cannot get a good night's sleep on a 3"-4" foam mattress!!
I think the most important item is how often does someone sleep outdoors. Once or twice a year, a foam pad is probably never going to work. Every weekend, then yes closed foam will be fine.
Another important item, IMO, is what kind of physical condition is your body is in. I am thin and in fairly good shape, and that probably is helpful.
I don't have any back, muscle, or joint problems.
Pretty rare for me to go below freezing temps at night, except a few trips each winter that may go down to 25F. Here is what I use:
Cold or lots of rocks, peebles, debris in deserts -
1/8" full length GG ThinLight, with a BPL TorsoLight. Pack under legs.
Above freezing in deserts, with good chance of mostly sandy ground -
GG 1/8" ThinLight with a GG NightLight Torso, or a trimmed GG 3/8" torso size foam pad. Pack under legs.
In mountains - GG NightLight Torso or trimmed GG 3/8" torso size foam pad. Pack under legs.
My wife refuses to backpack, because she is NOT sleeping on the ground. But if you were willing, there is no doubt an air mattress would be used. I have a feeling the same is going to be true is mamma is going to be happy. If she isn't happy, no one is happy :). I have never used one, but a DAM sounds interesting.