Hi 1sty,
The first place to start with any mattress research is post #1 here which has all the basic information, steps, and guidelines you will need to make the most suitable choices (and of course avoid the worst ones)
You can read my thoughts on airbeds in this article.
This will depend on the size you are looking at of course but in most cases (for a queen certainly) this would be enough to purchase a good quality memory foam mattress yes.
Some of the better options and possibilities I’m aware of in the Southern NH area are listed in post #4 here. There is a wider range of choices listed in post #2 here that may also be worth considering even though they would involve some longer travel time.
Phoenix