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.