Jarring is used to describe something or someone that has a harshly concussive, disagreeable, or discordant effect. The word also makes reference to something or someone incongruous in a striking or shocking way. In this case, it describes the noise produced. As you can notice, it does not have a positive connotation in the sentence and the following sentence affirmed it: "everyone quickly covered their ears!"