There's no time limit. Yes, you could still log back to your nsec as long as you still have it.

Account deletion is basically just putting `deleted: true` in your metadata. When your nostr client detected it, The client refuse to continue any further (r: Apple ToS).