The only terrifying thing to think is the total transactions in the mempool, because after all, that's bitcoin.
I'm not sure it's a problem. Difficulty will always adjust to gain the same average of 1 block per 10 minutes. So it might create a temporary backlog but only until difficulty is adjusted. And by then, 2040? I'd be surprised if more scaling solutions aren't implemented or people aren't just using L2 for micro txs. A lot of time in between to address.