Used with the emphasis on the 'had' when something is a let down or has disappointed, especially when the speaker was very excited about the something in question. The point is that the erection is no longer there.
Billy: 'Dude, that show was totes rubbish, I mean, I had an erection'
Bob: 'Homes, I know exactly what you mean. I'm totes flaccid now.'