No. Power Automate Desktop requires your machine to be connected to the internet. Regardless of the license you use, you will need internet connectivity for it to run. The machine will also need to be on. The unattended run mode will simply mean that the flow will login to your machine when it needs to run, but it will need to be turned on.
If you do not want to keep your machine on at all times, you might want to consider hosting this on a virtual machine on some server or even buying a hosted RPA machine from Microsoft.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.