INTPYTHON-806: Migrate from Motor to PyMongo Async API before deprecation

[ngcammayo]

Motor, the async driver for MongoDB, is being deprecated in favor of the new asynchronous API introduced in PyMongo (v4.6+). To ensure long-term compatibility and take advantage of first-class async support, please migrate to PyMongo’s async API.

[Jibola]

Hey @ngcammayo thank you for raising this issue!

We've filed a ticket with our internal python team to triage and tackle this in due time. To check the status of it, please take a INTPYTHON-806 - [FARM] Migrate from Motor to PyMongo Async API. If you would like to take on this work yourself before the change goes in, please do so and we would gladly review it.