The database connector you are using insists on strict hostname (CN) verification while the certificate provided by google cloud does not specify one.

You can configure your connector's ssl policy to be less restrictive, or better, use a connector provided by google cloud. For example with jdbc or r2dbc it is easiest to use https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory