It's not easy to say which type of motivation is better for training - both are important. It all depends on your goal as an athlete. If you want to succeed in a competitive environment, where your achievements can be recognized by others, then it makes sense to be intrinsically driven. On the other hand, if you just want to go through the motions and feel no emotion during training, that's also fine. It's up to you to decide what kind of attitude you want to have.