Prospects for Memory Detection with Low-Frequency Gravitational Wave Detectors