You set goals with excitement—only to lose steam weeks (or days) later. Here’s why motivation fizzles out and what actually keeps it alive.