Both foosball and air hockey tables take up a lot of space. My son had a foosball table in his room, along with a twin bed, a desk, and a chest of drawers, and it was pretty cozy (the room is 12' x 14'). I'm afraid you won't have room for much else up there. Maybe pick one table or the other?
Do you need both closets up there? If you took out one closet, you could either mount the TV in the resulting alcove, or use that space to move one of the game tables out of the way when you want to use the space for computer games.
Q