BPS Decoupling Limits of String Theory and Non-Lorentzian Quantum Field Theory