So I recently took on a new client and they have 500+ redirecting URLs on their site. The Better Search Replace tool already existed on the site but it was my first time using it and I tried it on some of the redirecting URLs and for some reason it's not working at all. I tested it a few times and the old URLs are still there. I made sure to do the search and replace for ALL tables too to make sure the URL is updated everywhere but again, no changes. Does anyone have any tips? Or recommendations for a different plugin? I really don't want to update 500+ redirects manually lol

Try wp-cli search-replace maybe