Fix RPATH issues on MacOS

[GregoryComer]

Wheel builds from CI (such as RC1) aren't working on MacOS due to absolute paths from the CI build. Mergen has written up more details on the problem in the fix PR for 0.7 release: #13254. We need to fix this issue for 1.0.