How realistic was it for Fredo to think that he was "passed over" ?

I mean, every guy has a reputation that stays with him. Everybody knows that Don Michael killed Sollozo and the police chief.

Everybody also knows that Fredo froze and started crying when the hit took place on his father.

He had to be completely delusional to think that he could ever be the Don after that.