People often confuse ambition and competence, ambition can be a poor quality, competence however is a necessity. If he made cardinal he was likely competent and somewhat ambitious, but not necessarily pope-level ambitious. Sometimes, that really does make a good leader.