Wondering if this console is going to be salvageable?

I was given a broken Xbox One 500gb for free and was hoping that I would be able to fix it and still use it. I don't know much about the repair process so I thought I would ask you folks.

Apparently a disc got stuck in the system and somebody wanted it out really bad. They messed up the case pretty bad prying it off and apparently didn't have the right screwdrivers to get into it any further and instead just started prying the corner open by the disc tray. It looks like after they got it open part way they just reached in and ripped the disc drive out then pried the drive open to get their game out. I'll have to buy a new disc drive but I'm okay with that if I could get a basically free xbox out of it.

It really makes me sick how they went about it so I am really hoping to give it a second life. I brought it home and took it apart the rest of the way and it actually doesn't look too bad. I pulled the hard drive and put it in my desktop and could see it in the disc manager so it looks like that's good and they didn't mess up any of the connections on the back.

The main problem I see is one of the little round red and silver things sticking up from the motherboard got broken almost completely off when they forced the disc drive out. Do you think this is fixable without putting a bunch of money into it? I don't have a power cable or any controllers to test the system with right now so I don't even know if it turns on but I am working on getting those from a friend. If anyone has had any experience with something like this I would appreciate any input you might have.

This is the part that is broken