Will the HyperX CloudX Stinger Core Wireless turn off automatically when the console is powered off?

Yes, like the Xbox controller, the headset will turn off automatically if the console is powered off. Conversely, powering on the headset will power on the console from standby mode.