After snapshot restore on new URL it redirects to old one.

After managed backup was restored from to by using snapshot-installer.php it still redirects to

In wp-config.php it still shows old site URL for DOMAIN_CURRENT_SITE and when that's changed to new URL it will show that it's unable to connect to database but the DB details are correct.

Further info can be found in chat.