Add SQLite vector backend as default and fix HNSW test skipping

Replace legacy memory system with HierarchicalMemory