It would have no use, a private key for Nostr needs is exactly like a private key for a lightning node. It has to be online all the time in order to sign notes. Otherwise you just have a dead, unusable account.

What you could do is put the private key on a secure enclave inside of a hardware wallet, but it would still need to be connected to a device that is always online in order to be functional.