The opposite is actually true. I sleep a month a year on a camping pad, and it's well known among avid backpackers that air pads like that shown in the OP are most comfortable when under inflated enough to keep your hips just above the ground.
you'd be surprised how little you need to inflate these types of things to be comfortable. Often times you only fill it 60% or so so it has some give when you lay on it.
Yeah, I was wondering the same. We have some nice fluff about air pressure and moving large volumes of air, but no indication of how any sort of pressure is achieved.