My motivation for being a good drummer was born out of fear, which, in a way, seems so antithetical to what art should be.

The quote means that the speaker’s original motivation for becoming a good drummer was coming from a feeling of fear rather than a desire to create something artistic. This idea of being motivated from fear to do something seems to be opposite to the idea of what art should be – that people should be motivated by the desire to create something beautiful.