I've been in this situation many times. Managers have different reasons and excuses why a certain promotion is not possible. It can be a budget issue, you don't fit the expected Lead profile, and your hard work and proactive behavior are not visible enough.