In that scene I also liked his hat. But, as the novel states, after the Don's meeting, Vito instructs that Sonny's Regime is to be disbanded and the men placed in Clemenza's and Tessio's Regimes. So, yes, Cicci migrated to Clemenza's Regime and he eventually achieved capo rank.