My sister's field is exercise science, and in the course of trying to help her find positions relevant to her area, I have found far more positions that wanted someone with a degree in kinesiology or a related field than positions that wanted someone with a degree in psychology. So I don't think that would be a problem career-wise while you work in between.
Conversely, for academia the name of the program doesn't matter as much as what you are learning. For someone who is specifically interested in sport psychology and aspects of that, I think a kinesiology degree that explicitly concentrates on psychological aspects is just as useful as an ed psych degree that concentrates on sports. The coursework will likely be relatively similar, perhaps with some exceptions (there are some things that exercise science/kinesiology students learn to do biomechanically).
Add to that that MSU is better-reputed in your field, cheaper, has good sports teams and you like the campus more - I feel like that's your answer.
I think it's SO nice when people who have been admitted in the past come on here to share insight with current applicants. Once you go through the stress of getting caught up in this process, it's uber generous to remember and revisit this site to offer your two cents when you can.
One of my recommenders is a graduate of one of my top programs, and he's been so extraordinarily helpful to me throughout the process. Part of this is that he's a generous person, but also I see more and more that this is because he knows how hard and stressful and anxiety inducing all of this is, and knows how much it means to have any support/insight possible.