Migrate a website from Maria 10.4 to a Cpanel with MySQL 8.0

I need to migrate a Wordpress website from Cloudway hosting that uses Maria 10.4 to a Cpanel that uses MySQL 8.0.

Unable to upgrade the MySQL version on the Cpanel, or downgrade at Cloudways.

When I try to migrate using the Duplicator plugin it's encountering issues with Character Set and Collations.

The plugin says:

"character set and collation isn't supported on current database"

"The database where the package was created has a character set and collation that is not supported on this server. This issue happens when a site is moved from an newer version of MySQL to a older version of MySQL. The recommended fix is to update MySQL on this server to support the character set that is failing below."

Default charset and setting in current installation
DB_CHARSET = utf8mb4
DB_COLLATE = utf8mb4_0900_ai_ci

Need someone who understands this who can help me get the site migrated.