It would make the world of difference if when you deploy a new workspace any copy or move row automations would update to the new workspace not point to the template.
I have the same issue. We use a template workspace which we save as new when starting new projects. If the copy and move to another sheet does not update automatically to the relevant sheets within that workspace it renders the function useless.
For one off sheets its fine but for multi-project companies this is a big flaw.
This issue also impacts me when I copy "template" folders to create new projects within the same workspace. The row automations in the new folder still point back to a sheet in the template folder, while all other linkages are updated to occur within the new folder as expected.