The high-frequency and rare events barriers to neural closures of atmospheric dynamics