I got my e-mail, but I can't sign in on Club Nintendo from the PS3 browser. Looks like I have to go to the basement to give this a go...I'll post how it goes in a bit, since people seem to be having trouble.
EDIT: Aw, crap...I'm having the same problem. The link in the e-mail takes me straight to the "Reward Order Inquiry" page, and it claims my order is completed. I think they probably did a crappy job of making sure we all got unique download codes, and since someone else already used the one I was sent (and same for others having this problem), it thinks I have my game. If Nintendo gets enough e-mails about this, they're bound to realize the mistake and fix it. One e-mail from me, coming right up...


and now it's downloading. Hooray Roebuck (and Nintendo)! 