There's no doubt about the benefits of having dual memory cards, but I suspect that the added size and complexity of dual slots is understated. The Nikon D7x00 series has a card door that's the same size as those for CF cards, while the old dual-slot Sony SLRs had a space many times the thickness of the cards between them.
But what I want to answer is this: "Maybe the manufacturers want to artificially differentiate consumer cameras from pro models, but nobody looking for a $600 camera will buy a $3000 camera because the latter supports two SD cards."
Well… of course. Cameras are products designed to meet a certain price point, as are lenses, as are shoes, as are cars, as are computers, as are phones, as are chairs, as are watches. Nobody who buys a $300 Seiko Kenetic wristwatch will buy a $6000 Grand Seiko Spring Drive just for its continuously sweeping seconds hand, even though that's a definitive difference.
The good news is that the price difference between single and dual-card cameras needn't be all that great. In the current Nikon line the difference is about $400, and in exchange for that the camera gains a great number of far more significant photographic features. And when I show those cameras to shoppers in the store where I work it's typically those other features, not the dual SD card slots, that they ask about.
Perhaps as 4K video becomes more established dual card slots will be a feature that gains in popularity and migrates downwards in the price points. But SD card capacities continue to grow even as their prices shrink, and dual cards slots does directly conflict with the move to smaller cameras. Perhaps the future will be dual Micro SD cards – who knows?