The lesson for me isn't "don't use Pinecone", but more like "did you already max out Postgres?"

In many cases, it is going to save you time by having less infra and one less risk while you're getting started. And if you find yourself outgrowing the capabilities of Pg then you look for an alternative.