I will probably change the delete/sign out flow and explanations a bit because nostr is different from what people are used to.
The account (key) is stored on your device, in the app. When you delete it its really deleted from the app but your published profile and posts are still online, but you can no longer change your profile or post anything new, unless you also have your account (key) still in another app.