Is there evidence of explicit attempted blackmailing? Based on the screenshotted WhatsApp messages, it kind of seemed more like vengeance and taunting than extortion. There's surely an implied "this is what happens when you fuck with us", and an attempt to instill fear in Bezos, but I think he'd have to be really naive to seriously believe the threat of exposing an affair would actually get Bezos to tell the Washington Post to back off from reporting on Saudi Arabia. Even if that sort of thing has worked for him in the past, I think he's gotta know that's a pretty farfetched outcome for Bezos and WaPo.
Not defending MBS, of course; he's obviously a megalomaniac despot who brutally murders critics and probably does all sorts of other horrific things the public isn't aware of. But I don't see evidence of demands made by him or anything like that in the report.
If I were to bet on it, I suspect the primary intention was to spy on Bezos and his close contacts, with a secondary intention of petty revenge, and a third intention of intimidation. The Khashogghi thing felt like revenge, too, rather than some sort of cool-headed political calculus. You probably don't torture and chop someone up if you don't have a grudge.
Intimidation definitely is in the same ballpark as blackmail, but it's not exactly the same. I think he might just feel the need to retaliate against who he considers his opponents, due to his immense ego and upbringing. WaPo, and, by extension, Bezos, may have genuinely hurt his ego. He's probably the most powerful human being alive - in his own mind. He may not be wise enough to realize all of this stuff inevitably ends up backfiring on him, with a geopolitical sort of Streisand effect. Though the intelligence he gained from a year's worth of access to Bezos' phone might have made it worth it in the end.
If this is accurate, then the sources saying they were aware of the plan to hack Bezos' phone but not aware of an attempt to blackmail him may be technically telling the truth. Also, this is obviously all uninformed armchair psychoanalysis. I could easily be completely wrong about most or all of this.