Not all ScriptPubKeyMans will be able to provide private keys,
but pubkeys and scripts should be. So only provide public-only
SigningProviders, i.e. ones that can help with Solving.
Backport of Core PR18115 part [8/9] : https://github.com/bitcoin/bitcoin/pull/18115/commits/dc174881ad8498a6905ba282a48077bc5c8037a7