Yes, as the number of transactions grow the resource usage will grow over time. This is a known concern and is being addressed by both ethereum and other blockchain devs. Mostly by the concept known as state rent or state expiry + more sophisticated data pruning algorithms. I mean we are not running out of space to store all the useless tiktok videos, we shouldn't be running out of space to store value transfers either.

jopsel

bitcoin

Proof-of-Stake & the Wrong Engineering Mindset

What's "dumb" about it is the fact that data can only grow over time, and the resources can only increase over time.  Imagine wikipedia being downloaded to each user.  That's safest for the data, but inefficient by design and entropy should tell you the inevitable conclusion of approaching the problem that way.  Sharding is basically taking a flawed concept and applying another flawed concept.  So half ass redundancy.  That said, there's nothing dumb about any of it other than the obvious inherent flaws.  But no, I have no idea how else it could be achieved.lol