Rethinking Memory Mechanisms of Foundation Agents in the Second Half: A Survey