Deep Dive into Embedding Models for Agent Memory