Absolutely, it's a bubble, and I just can't wait for it to burst.
And the problem isn't infrastructure, of course, except in the sense that we have wasted much too much money on it. The problem is the, so far, lack of viable business ideas, or just ideas for how it can be used to improve people's lives, or how it can be used in non-revenue-generating sciences such as astronomy etc.
We suddenly have this truly amazing technology, but we don't know how to make use of it. We have the answer but not the question.
I've been faced with a similar problem at my job: All of a sudden, our database systems can now integrate with AI (LLMs, specifically), but what is the actual use-case going to be? That's much harder to answer than how to use these systems, find the data centres etc. And especially when people are already just happy with the systems/applications that we have, so they don't want to devote time and effort on it.
However, I think over time we will start finding use-cases for AI. It's just going to take much longer and adoption will be slower.
So yes, another tech hype bites the dust. To a large extent, at least.