In the Mafia, a "good" husband is one who has only one or two goumads, and doesn't either beat his wife or infect her with STD's. By that measure, Sonny was a "good" husband.

Carlo was an adulterer, a wife beater and a traitor. Also (according to the novel) a poor earner--the major Mafia offense.