My reverse sensor on top of the transmission was crushed just like yours. It really didn’t completely fail until 2 years later. It fully “clicked” into place, but ultimately something was wrong with it.
You can buy the oem cable for $25 but I think the transmission needs to be dropped for install...but I bought this guy and just did some reconnecting of the wires and it’s all good now.
https://www.wiringspecialties.com/rbspseco1.html
Might not be it, but if you have a squished oem plug it’s worth a shot.