The premise of the article is wrong. Async in Python is popular. I'd expect most new web backends to use it.
The article says SQLalchemy added async support in 2023 but actually it was 2020.