Add support for authentication over `core.async_ssh` by password #5272

Job	Run time
install-with-pip	23s
install-with-pip ([atomic_tools,docs,notebook,rest,tests,tui])	1m 16s
install-with-conda (3.9, true)	37s
validate-dependency-specification	11s
install-with-conda (3.10, true)	47s
install-with-conda (3.11, true)	39s
install-with-conda (3.12, true)	40s
install-with-conda (false)	44s
create-conda-environment	51s
tests (3.9)	45m 14s
tests (3.10)	45m 15s
tests (3.11)	45m 16s
tests (3.12)	45m 15s
	3h 7m 8s

Provide feedback