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

Job	Run time
validate-dependency-specification	10s
install-with-conda (3.9, true)	53s
install-with-pip	20s
install-with-conda (3.10, true)	44s
install-with-pip ([atomic_tools,docs,notebook,rest,tests,tui])	1m 22s
install-with-conda (3.11, true)	43s
install-with-conda (3.12, true)	32s
install-with-conda (false)	43s
create-conda-environment	0s
tests (3.9)	16m 53s
tests (3.10)	17m 38s
tests (3.11)	16m 32s
tests (3.12)	16m 55s
	1h 13m 25s

Provide feedback