I've lift consistently for years and I'm not sore at all after workouts. If I have to take a week or two off here and there for an injury, I'll be a little sore after my first few workouts but then it's done. With that said...if you are new to working out and you over do it, the soreness could be really really bad. Soreness is usually determined by the difference in volume and intensity. I remember one time, I did a new workout that I've never done before. Lots of core and my abs were so sore the next day, it hurt to breathe. Literally every breath hurt a little. Deep breaths hurt alot. Getting up from sitting or lying or even changing position while lying hurt. Lasted like 3 days. So the answer is...you are never "supposed" to be sore but whether or not you are sore....depends on your experience, consistency, volume, intensity, etc.