It looks pretty buggered to me, those two pins still attached to the motherboard would be fixable (by replacement) but the other two look like they've torn off the PCB traces with them (as you'd expect). It's fixable but - and I mean no offence when I say this - not by you, since you managed to rip the header off in the first place I imagine you're not overly familiar with how this stuff works. You need someone who can identify that type of header, get a replacement, desolder the broken pins then solder the new header on and patch up the damage. From experience I'd guess it would take about an hour, so it's not a big job.
I'm not an expert, but I am studying electronics and have been fixing stuff like this for a few years now.