Hi melknee,
Yes … the two main functions of a mattress are that it keeps your spine and joints in good alignment in all your sleeping positions over the course of the night and that it also relieves pressure points as well. Everything else that you can “feel” is more of a preference than a “necessity” (see post #4 here and post #2 here). Of course what you “feel” has little to do with the quality and durability of the materials inside the mattress because lower quality and less durable materials can feel the same as higher quality and more durable materials … at least for a short while until the lower quality materials begin to soften and break down prematurely.
The better options or possibilities I’m aware of in and around the Santa Monica area (subject to making sure that any specific mattress you are considering meets the quality/value guidelines I linked previously) are listed in the list for the Greater Los Angeles region in post #2 here.
As you probably know from the tutorial I would tend to avoid the major brands including Tempurpedic. While Tempurpedic does use good quality materials … they are certainly in a much higher budget range than many other memory foam mattresses that use similar quality materials that are made by many smaller manufacturers.
You can see my thoughts about airbeds in general this article. While any mattress can be a good match for a specific person because each person’s needs and preferences or the criteria that are most important to them can be very different … in general terms I would tend to avoid them unless there is a very compelling reason that an airbed would be a better choice for you in “real life” (outside of the many “marketing stories” that you will hear about them) than the many other options or types of mattresses that are available to you.
If for some reason you are committed to an airbed and you are convinced that there are no other types of mattresses that will meet your criteria then there are some other airbed options available to you that are listed in post #3 here that may be in a much better quality/value range than the Sleep Number you are considering.
There is more about the different ways that one mattress can “match” or “approximate” another one in post #9 here. If you are considering an online purchase then the tutorial includes a link to a list of some of the better online memory foam options I’m aware of (in the optional online step) and several of these make mattresses that are designed to approximate the tempurpedic line (including the Tempurpedic Cloud Supreme) and are in lower budget ranges. There may also be some local options that feel similar to you as well (even if they don’t have exactly the same layers and components in their design) but you would need to test them in person to see how closely they compare for you in terms of comfort and PPP and you would also need to make sure that they use good quality/density materials as well to confirm that there aren’t any lower quality materials or weak links in the design.
As I mentioned in my last reply the only way to know whether any mattress is a good “match” for you in terms of comfort and PPP is based on your own careful testing or personal experience … not on specs or theory.
There is more information about the quality of the materials in the Loom & Leaf in post #2 here (along with some of the other “simplified choice” mattresses) and a forum search on Loom Leaf (you can just click the link) will bring up more comments and feedback about it as well.
I would agree that if you are considering a mattress that you haven’t tried in person then a good return/exchange policy would be much more important for most people … particularly if you haven’t slept on a similar type of mattress as well.
While I can’t speak to the “comfort” of any mattress or whether any mattress is a good match for you in terms of PPP because your own careful testing (hopefully using the testing guidelines in step 4 of the tutorial) or personal experience is the only reliable way to know … outside of PPP the most important part of the value of a mattress is it’s durability and a mattress is only as good as its construction and the type and quality/durability of the materials inside it regardless of the name of the manufacturer on the label.
There are some comments about the Ikea mattresses in post #3 here and the posts it links to. While they do have some good quality/value choices … I would avoid their memory foam mattresses because as far as I know they all use 3 lb memory foam which is a lower density than I would suggest considering (see the quality/durability guidelines here).
Phoenix