Apparently hardly anybody wants decent-sized station wagons. Mazda had a wagon version of the Mazda 6 - the new model has no wagon version, probably because I don’t think they really sold very many of them. A few companies (mostly European ones, where wagons are still fairly popular) do a pretty good business in wagons, but the Japanese have largely abandoned them. I would have loved a new Honda Accord wagon, but they don’t have one in north America - the european Accord is a little smaller than ours, but they do have a wagon version.
The new Mazda "wagon" is the Mazda5. I use "wagon" in quotes because it resembles a minivan (but smaller) more than a station wagon.