Bad answer: lool what, stop trying to build a narrative that this game failed.
Real answer: Maybe? Who knows. The sales numbers were and will continue to be fantastic, I'm sure Sony will come out soon with some astonishing figure of how many copies were sold. But since we will probably never know how much the development cost and how much was spent on marketing, the real answer will probably be hidden in some corporate Sony presentation. But I think it was a big success overall.
While dev costs and marketing would have been steep there's no way they wouldn't cover them with the sales numbers we're looking at here. I don't know what the physical split (e.g. how much it costs to produce discs, shipping and how much retailers take), but digital sales alone will be around half of that 7m number (based on trophies tracked) which is over 200 million USD in digital sales alone.
I don't think anyone needs to worry...