lol first Axon casualty!
Don't worry this is an easy fix. The tabs don't actually do anything other than simply hold the USB connector on. Just solder them back on, and use extra solder just in case it happens again
What appears to be happening is that one or more pins has an intermittent connection, meaning that it only has good contact when you push down.
Get out your soldering iron and add a little more solder to each of the 5 pins. Be careful to not short the pins with solder, as its really hard to unshort them unless you have solderwick.
Let me know how it goes!