Bulk redirect update from CSV: in code or manually?
You either use hook_update_n as you described. Or, sync down TEST to DEV in pantheon, perform the task there as needed, and then sync the DB/code back to TEST from DEV.

The workflow that works best for you depends on whether your site is accessed alot by users and can have no downtime or disruptions, or if your sites workflow/content is more static.