Why such a massive flop?

No, genius.
It is that this film is a major downer.
2 hours of grinding the viewer with awful people and situations, all quite pointless.
It is deliberate. I can appreciate it, but also I can see that that's the recipe for a flop.