Well, having a large capacity SD card makes it easier to back up multiple lower capacity SD cards, no?
And as you say, some equipment will record to two cards simultaneously - some at daft Res and frame rates (though that's starting to hit the limits of the bus the SD card sits on). Sony, Nikon and others are beginning to support a card that sits on a PCIE bus.