Why does my erection go away so fast?

Most likely it is because the stimulation wore off and/or because your head got out of the game.  A particularly significant factor in this case is nervousness or over-thinking.