Do demos still download when your console is off?

No, demos do not download when your console is turned off. However, if the console is in a low-power state (like rest mode) and has the appropriate settings enabled, it can continue downloading content. Make sure to check your console's power settings to allow downloads in that mode.