Password change ticket API requires that a user you’re creating a password ticket for is in a database connection. Otherwise, the API will return this error: The user's main connection does not support this operation. This makes sense because auth0 does not maintain the password if the user is created with enterprise or social connections.
This is explained in these resources: