The simple answer is yes, the more complex answer is, it wont be the indie web
The thing is that when people say "I want a cool website", they are
not saying "I want to understand the underlying ideas and reasons of the indie web while I make a cool website" - they are just saying they want a cool website - and that's a big gap!
Up till now, if someone found themself attracted to this side of the web, it was normally because they had already started down the path of learning indie web or web revival ideals for whatever reason (they were techy, or an artist, or otherwise an odd-ball), and their website came out of that path. Even if they didn't know much about the indie web before arriving, its such a strong community pressure, that they would have encountered it very quickly anyway. You more or less end up learning about it as part of the process of learning HTML and CSS because it's are mixed into a lot of the tutorials and help spaces (like here).
That won't carry over into a larger scene; particularly if people are using AI-assisted site builders where so much of the friction will be removed; you'll essentially get a SpaceHey web; mostly pushed by aesthetic trends rather than a central philosophy. This is more or less true of every counter culture that has ever happened, so I don't have much reason to expect a difference here.
I don't see that as a bad thing as such; it still sounds like a more interesting web then the one we are leaving behind, and it will still get a lot more people involved in the ethics and ideals of digital life; and that is super important! However it wont be the indie web we have known, and I think it's going to be quite a painful experience for a lot of people who were attracted to this side of the web early on, and learned to trust that a personal site meant the person shared their values on tech

(that just wont stay true)
I'd also say there's a point when we should stop comparing personal sites to social media. Partly because I think social media is already a walking zombie and poking at it now is starting to feel almost mean; but mostly because it's providing a different thing to a personal site (its a communication tool) - it always should have been considered a different thing from a personal site, and we (everyone) are figuring that out slowly
EDIT:
I think there is a place for these types of websites, and elements of them can definitely be added to mainstream websites
It's possible your confusing Neocities / GIF heavy sites with the "IndieWeb"; the IndieWeb (capital) is a particular set of principles described here:
https://indieweb.org/principles and it does not involve gifs

However I answered as a more general indie web (non-capital), that's closer to the mix of fun design merged with some of the principles from that link that maybe you mean ^^