This is what we ordered and have in our RV. We really like it. It does have some memory foam but it is also has traditional springs. It is a night and day difference to the basic mattress they give you.
https://www.amazon.com/gp/product/B08BDR6QWX/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1