I think that lite is very similar to regular. I usually buy it because it makes me feel better about myself. I've also had the sugar-free, and while definitely not as sweet, it wasn't bad. I was surprised at how much it tasted like regular.
I have not purchased regular cool whip in years but I do know the consistency is different but not enough to bother you. I keep one in my freezer at all times. It tastes great - and my whole family uses the same kind