Can the Charging Port be repaired on an IPad Pro 9.7

By Apple possibly.

By you, depends on your level of skill with disassembly and soldering.

Take it in to Apple for diagnostics and see what they say. You are not forced to take them up on their offer if the price is not to your liking.

Make an appointment at an Apple Store to have a technician examine your device. Or contact Apple Support. That is the best way to determine whether the port can be repaired and what the cost will be.