Using a SSH password instead of a key is not possible because Host Key checking is enabled and sshpass does not support this

export ANSIBLE_HOST_KEY_CHECKING=False

ref: https://github.com/ansible/ansible/issues/9442