Even if SD cards failed at five times the rate of XQD cards, I'd still take two SD cards over one XQD card.
Why? Because, in order to lose your data, it wouldn't just be a matter of having both cards fail at some stage. Rather, both cards would have to fail at the same time, which is a far less likely prospect than that of a single XQD card failing. If they didn't fail at the same time, you'd just find out on the next frame you shot - when the camera writes to one card and not the other - and replace the cards, backing up the good one. Even if the camera didn't do that, at very worst, they'd have to both fail within the same 1000-2000 shots you fit onto an SD card, before you put them into a reader and realise one of them isn't working.
A shutter failure, or other camera failure, isn't comparable. When that happens, you realise the instant it happens and can change to a backup body. You also don't lose the photos you've already taken - as long as you have a backup body (and you should, on any important shoot or long shooting trip) you can keep shooting as if nothing happened.