For profits for Sony during PS3's lifespan, clearly no. Primarily Sony's fault, small part is due to GFC.
Relative to the total units sold of its 1st 2 entries in the console market no, but it's ended up doing much better than many would have expected after years 1 and 2.
Relative to total units sold of all other consoles ever released, it would be called a success.
In terms of being the globally dominant console, esp in the USA, no, not a success.
In terms of the Playstation brand remaining viable in the home console market, so they can successfully launch PS4 if they make the right technology and pricing decisions, yes, it's a success without doubt.
Chalk this generation up to experience, learn from the mistakes, move on and do better with the next console.
“The fundamental cause of the trouble is that in the modern world the stupid are cocksure while the intelligent are full of doubt.” - Bertrand Russell
"When the power of love overcomes the love of power, the world will know peace."
Jimi Hendrix