No, no power to coolant sensor when ignition is off.
Most likely your battery is weak/old. Have your battery tested. Or test it yourself... charge up the battery and wait a while... and then check your battery voltage... new is like 12.70V for full charge... I think like 12.2 is weak and 25% reserve.
Or do battery load test and see how low the voltage dip in 10 second.