Seems those are incorrect charts. Refer below link. Also NPS is not a good instrument, most of yours funds are locked till 60.
https://pib.gov.in/PressReleseDetailm.aspx?PRID=1895286
Isn’t the primary purpose of retirement fund is availability post retirement ?
Yes, But it’s not debt fund either, you could get better returns in other instruments. There is lot of analysis is going around it, please google once. If employee is under new regime and there is employer contribution, then NPS is good option.
I'm investing in all three options: 80CCD1, 80CCD1B, 80CCD2
which one is that? Are there 3 tiers for NPS?
there are tiers as well but that's a different concept there are three sections under 80CCD using which you can save tax. So you can increase deduction from 1.5L to 2L+
Yes.