From a financial standpoint, yes the PS3 is a massive failure. But then again so was the Xbox 1. From a commercial standpoint, the PS3 is a success, again like the original Xbox.
It all depends on what your looking for when you call it a failure as to whether your right or an idiot.