Revert "target_link_libraries: Allow use with targets in other directories"

Revert !2040 (merged). The RHS target scoping and visibility rules are not clear and will need further investigation before the feature can be added.

Issue: #17943 (closed)