Sure thing Rocco failed to secure the compound “he had failed in his task to protect Michael and his family”

This ridiculous security breach “in my home” would have been the laughing stock

“In my home! In my bedroom, where my wife sleeps! Where my children come and play with their toys. In my home!”

What happened in Michael's home was a disgrace! However it seems Rocco's incompetence was forgiven!

How is Rocco's 'suicide' [sorry, beg to differ Ref: below] mission was basically a way to redeem himself?

Rocco's killing of Roth need not have been a suicide mission at all
Rocco seems to have not planned the operation well, no escape plans at all
He could have easily shot Roth, camouflaging his gun and then instead of trying to run away in full view of the Federal agents, with the smoking gun still in his hand! could have just lost himself in the crowd The airport was full of people

Rocco could have even used a silencer if available back then

Among others,
Michael committed a double murder including the New York Police captain in a public restaurant
Neri killed Emilio Barzini including the driver, bodyguards, in public at the steps of the [court house?]

These murders were well planned, executed and the 'killers' got away