Currently there is a poll in community.mysql about dropping mysqlclient in the future, so that only PyMySQL will be supported.
If someone wants to participate: deprecate mysqlclient and support only PyMySQL · ansible-collections/community.mysql · Discussion #645 · GitHub