Oh, I agree with TB. Fredo's little tantrum in the boathouse revealed the depth of his anger and resentment towards Vito for handing the reins to Michael. Because he was incapable of hating his father (not to get to Dr. Phil'ish here), that rage was refocused on his brother. He would always be angry, and that anger would always make him a danger.