Imagine going back in time to 2015 and showing this article to someone.

I don’t know much about photography, so forgive me if this is a dumb question, but would something like focus stacking help with this?

That is to say, make the lens less of a bottleneck so you could benefit from a higher resolution sensor.