Mattress for old-school box spring with coils?

Giving our queen size guest room bed (seldom used) to our daughter, and now on the search for a replacement. Figured this would be a relatively easy task, until I realized that our box spring (which is staying) is the old-fashioned kind with coils (still in excellent condition though). This is a bed that will only be slept on a couple times a year at most, so don’t want to have to buy a new foundation in addition to a mattress.

So I’m assuming that I need to stick to a traditional innerspring mattress…or do I? Do certain hybrids work with these types of box springs? Or am I overthinking it and just presume that the coils won’t affect longevity too much if bed is only being used on rare occasion?