On Sunday I happened to park right behind exactly the car I would try to find and buy used if my occasional-use Volvo XC70 had to be replaced: a red VW Golf Alltrack wagon with tan leather and the big sunroof and 6-speed manual. (2020 was the last model year.)
I fantasized a bit about whether I could buy one and keep it long enough for my 9yo to learn to drive stick, but of course that would be a determinedly quirky and antiquarian skill to learn by then, like writing with a quill pen or using a coal furnace. (https://www.npr.org/2019/03/03/699325560/for-the-few-who-hea...) Also the used prices have gone up since I last checked a year ago!
(What will finally put the nail in the coffin of the manual is the electric car. And--yeah, I guess I obsess about this--electric wagons from Volvo and Volkswagen will be coming to the US in the next few years, though for various marketing reasons they both shy away from the word "wagon": https://www.caranddriver.com/news/a39263104/new-volvo-evs-wa... and https://www.reddit.com/user/HDiess/comments/soje69/hi_reddit...)