I agree that piracy is wrong (and don't actually have any pirate software on my computer.)
I've also hacked DRM schemes for games in the dim and distant past - not because I wanted to pirate them, just because it was a pain having to have the physical disk when I wanted to play it. That was years back when I had the time to disassemble machine code in my spare time.
I've also written the damn things (DRM things), although complete waste of time that was (and the company wasted loads of support time when people managed to break their licences or someone important needed the software on their other computer straight away or whatever).
I don't think the PC market for games is screwed because of piracy though, it is because gaming PCs are so ludicrously expensive nowadays, at least the kind of configuration that will get you a better than console games experience is. Even if you buy the games on the console, you'd have to play a lot of games to make up for the extra cost of a PC (and the cost of upgrading it every 6 months to play the latest game).
In terms of the DS, I think Nintendo really lucked out that it isn't so easy / widespread to pirate games. I know loads of people with a DS, and only 1 person with a dodgy card (who doesn't buy any games at all - that 'try before you buy' argument is just rubbish in most cases).
Piracy is an odd one though - I imagine maybe at some point it'll stop being a problem for games companies as most games devices will have online connections, so we'll play most games on servers, where the money we pay is for the server account. That would be a right pain (no more 2nd hand games), but I wouldn't be surprised by it at some point.
Joe