Dreaming that you are in a pit means feelings of hopelessness about some situation or circumstance. Also consider the familiar phrase of "being in the pits".