What would cause my tail lights to go out completely after plugging my standard trailer harness into the u-haul trailer harness by accident on a 1996 Ford Explorer?

It sounds like your power wire matched up with a ground wire on the trailer or vise versa so replace the blown fuse for the marker lights and everything should be good. Check fuses in cab and in engine compartment.