[Tech Debt][Cloud Security]Secret Field should have type 'password' instead of 'text' in Cis Integration page

[animehart]

Description: Currently in the Manifest file, all fields including those with secret: true is using type: text instead of type: password. While this doesn't seem to be affecting anything. This issue becomes more apparent on this ticket https://github.com/elastic/kibana/issues/172071 , where we are trying to use Fleet component to hide Secret and It will only work for type: password

Currently the way we handle it is by mocking the type to become type: password for the fields that supposed to render that Fleet component. However we should consider changing the manifest file to use type: password instead of type: text so we won't need to mock it anymore

[elasticmachine]

Pinging @elastic/kibana-cloud-security-posture (Team:Cloud Security)

[uri-weisman]

Verified, works as expected.