Well, Django 4.2 just added support for psycopg’s async database driver, so I’d say we’re making pretty good progress here. You’re welcome to use other tech if it suits you better.
If you’re serious here, you’re going to need a demonstration — implement it for a a subset of Django and show what it can do.
The approach used is the one asyncio dictates — asyncio is the approach to async provided by Python.
If you’ve a much better async implementation then a proof-of-concept to Python Ideas would be the place to go. If it were adopted there, we might use it here.