Fredo wanted respect as he explains to Michael in Godfather Part II. He claims he's smart and that he can handle jobs. He wants people to know he can handle the fmaily businesss and that he can take of his younger brother. He felt he wasn't being trated right in which this is his flaw and allows him to make the mistake of betraying Mike to Roth.