I think any air mattress is not a great choice for two adults. But for one you can make it work. If going the full sized route we have some
https://www.aerobed.com/. That we hide when the kids have spend the nighters. These have held up over the years even with kids jumping on them. I would recommend getting one that has a quite "top off" pump feature, this way you don't wake up on the floor or as a taco.
If comfort is premium look at Exped. I have a couple of their higher end ones for car camping. I sleep well on these.