For this setup, I'd keep the 24V PSU alive, and kill only the motor/spindle power with all E-stops.
I wouldn't involve anything other than a safety relay in the E-stop actuation process, as relying on the controller has the potential to cause an issue if it's because of the controller that you want to e-stop.