The lesson is to find a good-enough approach to content protection that is easy, convenient and non-annoying to most people, and then accept that there will be some leakage. Most consumers see the value in paying for something of guaranteed quality and legality, as long as you don't treat them like potential criminals. And the minority of others, who are willing to take the risks and go to the trouble of finding the pirated versions? Well, they probably weren't your best market anyway.
The last sentence is crucial, too: those who steal it were going to anyway. Maybe this RIAA-attitude will fade over the next generation, but for now, it's difficult for the rich not to get richer. Within every millionaire beats the heart of a secret lust for being a billionaire. So it's never enough.
Microsoft ain't stupid. They've repeatedly given away Windows and Office and let the Chinese steal it for years without too much of a fight in order to gain valuable market share. Their attitude is once you get them hooked, then they'll stay and buy other products eventually. It may be hypocritical and evil, but it's not stupid.