Fender Roc Pro 700

    It's hard to tell from the camera angle but the top of the jack body may come off, giving you access to the contacts inside. If that's the case, simply bending the contacts toward the center of the barrel may do the trick.

Maybe getting in there with a pick small enough to get behind the contacts and pull them up would get you up and running.

Also hard to tell from the video but there may be a cracked solder joint between the jack and PCB. Hitting the points with a hot iron might fix it too.

Worst case, I don't imagine that having the jack replaced would be too expensive. Maybe between $35.00 and $100.00, depending where you live.