Why is this necessary? we have built in full-text search in postgres?

It's almost as if there is a blog post that explains what's different

slop

If you mean the blog post is slop, you are 100% wrong. PlanetScale’s blog posts are all human written. I cowrote the TIN post with TIN’s main developer, and several of my very human colleagues reviewed it.