[3.13] gh-71019: document which objects connect_read_pipe/connect_write_pipe accept and add tests (GH-153660)

[3.13] gh-71019: document which objects connect_read_pipe/connect_write_pipe accept and add tests (GH-153660) #278378