pymssql does not support Azure Active Directory Authentication yet.
I suggest you use pyodbc instead. I also have tried for many times in airflow, but all failed.