I like the idea of calling this the small web, I usually go with something like "personal web site" or "home pages" but it's never quite stuck for me. I hope they've added Neocities to the Kagi small web search because there's some pretty incredible sites available for that and our compiled sitemap will make importing easy: https://neocities.org/browse
The framing for this stuff is usually something like "wow remember the crazy 90s web" nostalgia pieces or "this is an active resistance against Facebook come join us in the lonely space nobody goes to." But really there's some incredible, magical content that requires the canvas the web provides, that isn't on the social media super-platforms and people very much still use the web to access them. Neocities alone serves hundreds of millions of views per month across all the sites, there's still a lot of web surfing going on.
I would actually argue that having a web site gives you more exposure for your content than an average social media account, because sans a few lucky accounts, most are being throttled and limited by weird algorithms to prevent people from seeing your content organically. Your google search ranking might not be great, but people share links all over the place, including in private channels (think Slack/Discord/IRC/IMs) and you can still get meaningful distribution of your content this way.
To paraphrase @izs "if you build it, they will come", is a misquote from a Kevin Costner movie about baseball ghosts, but if you build a good site with good content, people do just magically show up through mechanisms I don't myself quite understand yet. It's pretty cool to see new sites on Neocities that are unusually interesting and know they'll organically get view counts into the millions before it happens.