[Framework] Clean up native connector secrets code

[jedrazb]

Problem Description

We no longer rely on connector secrets in 9.0.0 for agentless managed connectors. Go over the code and clean up the usages: some tests and logic were removed in #2989, more thorough cleanup is needed