My first conclusion was that this is essentially unrepairable by a normal human being
You are correct. If this is your laptop, and if this is your first time, you are risking lifting the pads. My advice for you is to give to a reputable repair shop, spend some money. Otherwise, you lift pads, you can't fix that, you spend even more money on repair shop service, plus not every shop is going to take your stuff with lifted pads.
If you are experiences professional, you are still risking lifting the pads. Difference is that you have microscope and are able to repair that. But there is a caviat, if too many pads are lifted, as a professional valuing your time, you might just say no to this type of repair.
Anyways, tools:
Microscope (a must)
Solder iron, smallest T12 tip or better
Heat gun, good temperature control, fish pump type
Low melt solder
Solder
Wick
Flux
Tweezers
Spatula / metal opening tool
Connector is glued at the bottomYou apply flux and low melt solder to the holding legs at both sides
Then you use your hot air to melt solder and remove the connector, keeping in mind that it is glued, so you need to lift it with your spatula. Without lifting any pads
Then you clean with the wick
If pads were lifted you repair pads and tracks
Apply new solder
Reinstall new connector with hot air
Solder holding legs at both sides
Ideally hot air is applied from the bottom, but this is not always possible. Often you work from the top. You might have plastic around, so you work around that masking stuff. In rare situations you might have to take off some plastic parts prior to doing your job.
First timers lift pads, blow off and lose other components like caps and resistors, melt new connectors. You won't save any money if you do this one yourself.
