Running the updateConnectionProperties function in ArcGIS Pro does not update the paths of related tables if the relate is created on a standalone table.
The user's script works for me. I suspect the following - UpdateConnectionPropertie is case sensitive (to support Linux). Check the case of the path strings and re-test. Version 2.4 will have a parameter for case-insensitive searches.