Anyone in sport/exercise psychology?

I’m really interested in sport/ exercise psychology. I know there are few jobs available. I would also have to move states for a masters in sport psychology specifically. Is a PhD in psychology worth it for more money? I feel I would be underprepared for the sport aspect of it. If anyone went down this path, I’d love to know how you got there. Also I’m looking for jobs that I can get with my BS in physical activity and health that would be better than a fitness trainer at a gym.