I assume you mean Short Queen when you say standard RV Queen. Some RV will support a standard Queen like you'd find in any Mattress place while most have the Short Queen.
We replaced ours for the same reason last fall. The foam is also too warm for us. We purchased an inner spring from Parklane (short queen by the way) and after a brief "get to know you" period, really like it.
We had the advantage of buying from a local Parklane store (they are made near us) they sell on Amazon as well. They offer a couple different inner spring versions and a foam mattress as well.