We got an aero bed for our MH. The first season, we only got to go out two times. Then it was stored for the winter. In the spring the second time we went out, the thing would go flat. Got to the point whoever got up for a potty call pumped the bed back up so we didn't wake up on the board in the morning. By the time this happened, even though we hadn't slept on it that many nights, the warranty was expired.
It did not pop, it just kept slowly leaking air.
We went to a sleep number. At first I wasn't wild about it, but didn't want to say anything due to what the DH spent for it. But the more we used it, the more comfortable it got and I love it now.
We have a waterbed at home too, and my back just won't handle a standard mattress. If I sleep on a regular mattress, I won't be walking the next day.