No, following someone on Duolingo adds them to your Friends List, where you can compare all-time XP. The leaderboard is a separate feature where you compete with Duolingo learners in a weekly XP competition.