This story is getting a lot of press, but the term "supercomputer" doesn't really have a lot of meaning when used like this. It's a cool approach to be sure, and PS3's (the Cell CPU basically) are indeed very useful for this kind of thing. Sony is selling them at a loss so it's a deal (unlike pretty much any other computer hardware you can find). But they're also, as o_b said, a pain in the ass to actually take advantage of, unless your task just happens to map very well to the Cell way of doing things. You're not likely to see TG2 on Cell/PS3 any time soon at any rate...
- Oshyan