Why did I feel this colonoscopy, when I didn't the last one? I was given demoral.

Hard to say. It is hard to pin point exactly why you feel this one but not the other, factors may include different sedative med use , colonoscopist technique may be somewhat different etc...
Not enough sedation. You prob didn't have enough sedation and pain control.