For some reason if you create a new user on your mac, install cursor from scratch, importing no extensions, then install python, it will install Pylance (a version that seems to work in Cursor).
You can then copy that from ~/.cursor/extensions into your original user folder and then magically Pylance does work.