I think Wagons still have a market - it's still just more of the outdoor enthusiast/camping type. I love my Subaru AWD wagon and would likely get another - or upgrade to something nicer like an Audi, if had the money.
I think the problem with the Magnum is that it was trying to cater to too...