While Shlomo Carlebach’s niggunim continue to inspire many Yidden, he displayed his weaknesses publically and more so privately and that, in my opinion, denies him any consideration from being included in the league of greatness in his lifetime.
Of course, he is a Tzadik now as are all niftorim, ultimately.