Hi @tai_ho
If you are moving all the product images to s3, you should export the catalog to cvs, then change all the product images links to s3 and import the catalog.
This way all product will link the new root.
I hope this will help you. Any questions, feel free to make an appointment here:
https://magento-specialist.com