For those who have a similar issue, the team has found the cause: it was coming from the wordpress version. The WP backup version was older that the new website version.
They successfully restored the backup to the new site after excluding WordPress core from the backup zip, then uploaded all other files, and restore.
Many thanks to the team, you are the best!