CAGR works for one lump-sum investment held over a stretch of time. XIRR is built for money going in at different dates, which is exactly what happens with SIPs.