Sorry to hear you want to leave Spotify.
This doesn’t apply to your Profile name; it only applies to your username. You won’t be able to use your username again after you delete your account.
You can learn more about deleting your account here.
Hope this helps 😊