Procedural Memory Is Not All You Need: Bridging Cognitive Gaps in LLM-Based Agents