[backend] handle orphaned auth user on signup failure

[polter-dev]

If supabase.auth.signUp() succeeds but the profile insert fails, an auth user exists with no profile row. Add cleanup logic to delete the auth user if profile creation fails.