In reality, the tax relief is way more than what we are led to believe once you start to reinvest the original tax relief amount. Am I understanding this correctly?
It depends on how you do the sums.
Scenario 1:
I know I'll have 20K to invest into my pension once all the tax relief is sorted. In order to get 20K into my pension I need to pay in 16K - but because of tax deducted at source I've only got 12K in my bank account. I borrow 4K, pay in 16K and once I get the 4K back from the taxman I repay the borrowing (from a wealthy friend who doesn't want interest

)
Scenario 2:
I've got 12K in my bank account. I pay it all into my pension. The pension reclaims 3K - so there's now 15K in there and I get 3K back from the taxman.
Now I pay that 3K in, the pension reclaims 750 - so there's now 18750 in there and I get 750 back from the taxman
Now I pay in that 750, the pension reclaims ~200 - so there's now ~19700 in there and I get ~200 back from the taxman
Now I pay in that 200, the pension reclaims 50 - so there's now ~19950 in there and I get 50 back from the taxman.
Repeat for an infinite number of steps
... so there's now 20K in there
At the end of the day you end up with 20K in the pension either way, just one way gets it all in in one year, the other requires an infinite number of years to converge...