Rock climbing is fantastic, but as your claim that it doesn't make you 'fit' are a bit misleading. As with anything there are correct techniques and if overall 'fit'ness and being able to run a mile are related then you're doing it wrong in respect to your goal and you've probably chosen the wrong form of exercise.
Continuous bouldering again is a great way to work your cardiovascular while also stimulating your core. Slow top roping on the other hand won't be the same.
As seems to be the grandparents goal, you will definitely get a sixpack from rock climbing.
For cardio, you could also do top-rope laps. Pick a route slightly below your peak, climb it, descend, climb it, descend, climb it, descend. It's fun to see if your technical improvement by the third time compensates for climbing slower because you're tired.
And FWIW, I've been climbing 2 times/week for 3 years now and have no where near a six-pack :)
The only downside is that it won't actually get you fit in the traditional sense. I can pull into a front lever using two fingertips, but I can't run a mile to save my life.
Still, it's exercise that you'll actually do. And unless you live in Nebraska, there's a climbing gym within a 20 minute drive of you right this minute.