I am working on #51873 and there are some occurrences in providers where they use get_password in place of just using password.

The SDK connection doesn't have get_password and no need to have it because it only exists cos of:

    @declared_attr
    def password(cls):
        """Password. The value is decrypted/encrypted when reading/setting the value."""
        return synonym("_password", descriptor=property(cls.get_password, cls.set_password))

It defined a dynamic password attribute in a SQLA to Map to the _password column (synonym), not relevant anymore as its a class now.

^ Add meaningful description above
Read the Pull Request Guidelines for more information.
In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed.
In case of a new dependency, check compliance with the ASF 3rd Party License Policy.
In case of backwards incompatible changes please leave a note in a newsfragment file, named {pr_number}.significant.rst or {issue_number}.significant.rst, in airflow-core/newsfragments.