You would need to replace the whole connector to get the metal shield as you call it.
I'm guessing one of the following will match up pretty well, but lead to quite the soldering event:
https://www.digikey.com/short/vb8n4hwc
However, I believe all DSUB screws are 4-40, and it looks like the plastic shoulder is still there, so you should be able to get some 4-40 screws and mount them up anyways. It should be noted that the metal shield is grounded so it would follow that it may be important to ensure the 4-40 screws conduct the ground instead.