The drunken feeling probably has something to do with the balance of O2 and CO2 in the shuttle. You can probably fix it if you mess around with the bunsen burner contraption.
I was able to cook the food. There is a can opener
Spoiler:under Nicholl's body.
I haven't managed to get all the pictures yet, either. Still wondering what triggers the end of the demo. But I have been restoring from a save game after the I got the oxygen levels up again; think I need to start again from the beginning and do more before I solve that puzzle.