It's not yawn, but not because it's great. It's because it'll be around for just long enough that it will create reliance on it, ruin many things, and then those people who have become reliant will find themselves in the position of having to unruin the many ruined things without the crutch to help them.
Or maybe I'm being the next iteration of the schoolteacher or parent who said that you won't have a calculator in your pocket all the time.
But then, a calculator doesn't need a terabyte of RAM. We're a ways off that being consumer-affordable as yet. If past consumer RAM size trends are anything (and the only thing) to go by, a portable LLM would be a 2040s or 2050s expectation.
Assuming that you'd be allowed to have the terabyte of data for nothing, anyway. Exorbitant subscription models are likely to be the norm by then.