Agreed, it's okay for an MVP but not okay for a real app.
"for item in ... if item.containsSubstring(query)"
I would say it's definitely useful for real apps.Once you start exiting that and start touching document search, being able to sort on relevance OR date with indexes, or any data ingestion killing search latency, you will have wished you went to the vast and uniform area to the right of db fts called elastic search. That is where I found myself.
If search is not integral to your product, by all means avoid the complexity and curve that is elastic and be happy that you did.