FindPkgConfig: Revert "Populate _STATIC_LINK_LIBRARIES. Add STATIC_TARGET."
Revert the main change from !7070 (merged). Several regressions have been reported. Revert the feature pending further discussion and design work.
Issue: #21714
Fixes: #23642 (closed)
Backport: release