The main difference between I/R and wired is the amount of control. The wired VISCA protocol allows for more precise control of pan/tilt/zoom and access to other camera functions not available on the handheld wireless infrared remote.
The Sony wireless remote controls only zoom (2 fixed speeds), pan, tilt, automatic or manual focus, back-light, 6 preset positions and power. A nice feature is that one remote can independently operate 3 separate cameras.
In contrast, the Sony RM-BR300 joystick controller offers a wide range of additional adjustments not found on the wireless remote like servo pan tilt and zoom speeds (it's BEST feature), control of brightness, iris, shutter speed, gain, white balance, red/blue color fine tuning, etc. The controller can also operate 7 different cameras. This is accomplished via wired RS-232 or RS-422 protocols (usually over CAT5 cable) but requires data communication via a computer or joystick controller. Free PC software can be downloaded from Sony and there's even a program in one of this forum's posts to control this camera via PC.
IMO, I found PC control with software difficult to use since you need to look a the computer's mouse pointer (direction and speed of pan/tilt/zoom) and at the same time, watch the monitor to see what you're doing.
(Since the post made reference to an I/R repeater, I assumed he wanted hand-held remote wiring instructions.)