Water pump replacement is straight forward procedure. The SurFlo Revolution is a good choice. I just replaced my old pump with the SurFlo.
The water connections are basic 1/2 plastic pipe threads with elastomer seals. The 12v
wire are best connected with crimp style connectors. Some folks use wire nuts. Then screw the pump to your subfloor. You don't have to use the old hole pattern. The pump comes with rubber feet for noise and vibration reduction.
The only difficulty is working in the tight confines where the pump may be located.