I have found a temp walkaround, after manually delete the:

~/.vscode/extensions/ms-python.vscode-pylance-2024.12.1/dist/bundled/stubs/django-stubs folder

Pylance is picking up the right definition. It's likely a django-stubs configuration error on my side.