Moving a site is more than moving the database. And it is more than updating the wp-options table's URLs (although that is important). You also have to change any references to the old URL in the database.
I use a plugin called "Better Search and Replace" to update the URLs in the database. (There are other similar plugins; this is the one I prefer. YMMV.)
But I also use my own procedure, developed over many site moves, to properly move a site from one place to another, whether that be a development-to-live move, or a move to a new hosting place.
The process is too long to post here. Here's the link: https://securitydawg.com/moving-a-wordpress-site/ . If you follow all parts of that procedure, you will have a successful site move.