What do I need to do to bring this bike back to life?
I would start by just trying to pump up the tires and see if they hold air. Then put some basic lubricating oil on the chain and gears. That should be enough to make it basically rideable so you can use it. Once you are riding, you can decide what is most urgent to work on next.