Tim Sloan was a “great” CEO for Wells Fargo, and it’s “unfair” that he has to step down, management expert Jeffrey Sonnenfeld told CNBC on Thursday.