I think this example app was intended to show what you can do with postgres functions to easily handle signups.
public.handle_new_user() is a great starting point but perhaps it shouldn't be part of the default schema to start with, and maybe something that you can add later as a more advanced step in setting up your supabase project.