Agent Memory's Reality Check: Why Simpler Retrieval Keeps Winning and Harnesses Split Brain From Hands