I don’t think it’s either-or, this will probably become the default / go-to - if you aren’t storing your vectors in your db like Neon or Turso.
As far as I understand, Milvus is appropriate for very large scale, so will probably continue targeting enterprise.