Yes, the team with 10 enthusiasm at normal will be more effective than the team at 8. If the level of enthusiasm had no effect, you could in theory play CT every game with no consequences.
On top of that, there's some line (I don't know where), where a team with high enough enthusiasm playing TIE will be more effective than a team with lesser enthusiasm playing CT.