gh-71019: document which objects connect_read_pipe/connect_write_pipe accept and add tests

gh-71019: document which objects connect_read_pipe/connect_write_pipe accept and add tests #278356