Or indexes, which are after all a structured way of duplicating data for performance, sometimes so much so that they entirely replace the actual table row lookup.

Yeah that was a lot of words to say caching is needed sometimes.

As always it's an engineering decision full of tradeoffs. You should never duplicate your data, except when you need to...etc etc.