I dont think you can pass an ssh password with exec node like that .. try bigssh node (havent used it)
Most would recommend creating a python script on the remore PI that sends your sensors data with mqtt to Node-red.
that would involve setting up an mqtt broker (mosquitto)