Clarify where socket.error is translated to ConnectionFailure

PyMongo should raise only ConnectionFailure or its subclass AutoReconnect, never socket.error. Clarify which layer, internally, is responsible for translating socket.error exceptions.