"If you were plowing a field, which would you rather use?... Two strong oxen or 1024 chickens?"
- Seymour Cray
There are a lot of other great Cray quotes.
Sparc isn't failing because it's inferior to x86. Sparc is failing because Solaris is failing, and no other OS is built from the ground up for Sparc. You can run Linux and other Unix-likes on it, but given the choice between x86 and Sparc, you choose x86 because that's what's least likely to cause incompatibility issues.
Cray got reborn in the form of SGI's Altix, which to abuse the analogy would be a pack of wolves compared to the POWER bulls.
The successor to Altix is an x86 cluster using the same high-performance, zero-latency interconnects that they used in Altix (part of the technology that SGI gained from the Cray acquisition).
x86 costs quite a bit less than Sparc. It has far higher performance than Sparc. It runs everything that Sparc does, including if you want it, Solaris. So what's the selling point for Sparc?
Java? Oh, wait -- that's what enabled everyone using a Sparc server to save money by abandoning it.
Amazon saved $17 MILLION by dropping Sun. Ebay dropped Sun (and saved millions in maintenance costs as a result) after a 2-day outage because their Sun boxes crapped out on them, and Sun support dropped the ball.
There are others, of course. Sun tried to stem the bleeding by partnering with AMD, and also by acquiring Afara and attempting to put their CPU designs into practice. x86 ended up beating them at their own game -- lower power consumption, higher throughput, lower cost...
Sparc's probably doomed. I think that Oracle bought an albatross there. There is some worthwhile technology that they might be able to use, like the system interconnects that Sun got when they bought the company that made the Connection Machine, assuming I'm remembering the name correctly. (Thinking Machines, IIRC?)