but isnt the whole thing about karkat is that he actually sucks at being a leader?

No, he’s a good leader, but he doesn’t think he is. It seems to be a running theme with Knights to not like/not think they’re good at their Aspect.