Building AI Memory at 10M+ Nodes: Architecture, Failures, and Lessons