Hey there.
You can either uninstall the Github application on the existing organization (which will allow you to bind to a new organization in the organization-level Administraiton > Organization Management), or this will happen automatically when you delete the organization.
Will you be transferring your existing repositories to the new organization? I would recommend making sure that your new organization is successfully bound to your existing SonarCloud organization before deleting your old org entirely.