I’m a little suprised that the OP called me out by name … but I’ll give you a short thesis… or perhaps a long one.
Without regard to secular vs. sacred, different styles, modes, and keys will affect people in different ways and illicit different responses. Tonal music has developed two of the six Church modes into common use, Ionian became major, Aeolian became minor. Within tonal music, major keys will typically be cheerier and happier, while minor keys will be more sad. Keys such as D Major and G Major will be very bright sounding (D Major is sometimes call the Sun Key), while Bb and Eb (the Band keys) will be darker.
The song that almost made the OP cry was probably in a minor key, while Glory and Praise to Our God makes a nice recessional because it’s in G Major and is thus cheerier.
So right off the bat, how modes and keys are used will affect people’s moods and responses.
Styles will affect people too. More upbeat music will make people happier (and might cause them to clap), while “down-tempo” music may be calming. Most traditional hymns, when played at a fast enough tempo, will be very upbeat and happy. Even Holy God, We Praise Thy Name, in the key of F Major is very upbeat and happy when taken fast enough.
When you get into jazz and rock styles, you have the addition of a bass player, and possibly a drummer. A bass player will bring added excitment, as will a drummer. And, if the bass player is playing ever so slightly ahead of the drummer, it will cause a sense of anxiety in the listeners that is appropriate to the style.
Let’s recap the OP’s situation. If the music was in a rock style, in a major key, especially G or D, there was a bass player and a drummer, we have a recepie for the psychological reaction of the faithful at this Mass.
Are these appropriate for Mass? I dunno. I’m not a degreed-liturgist. It is my professional opinion as a musician that if you’re going to have a Contemporary-style choir, that having these instruments is desirable and appropriate. It is my opinion as a pastoral musician that the congregation is best served when there is appropriate variety to the music. If there are enough people in the congregation to support Contemporary music, there’s no reason not to have it at one Mass a weekend. Then people can decide which Mass to go to.
As for the sacred/secular debate… Sung music must have a text that is theologically appropriate for Catholic worship. “Contemporary Christian Music” often contains lyrics that are not theologically sound, or is downright heretical.
Instrumental music on the other hand … Bach didn’t write his Toccatas, Preludes, and Fugues for Catholic Mass… he didn’t even write all of them specifically for Lutheran worship, yet our Holy Father has had the Toccata and Fugue in D Minor as a postlude at several of his major Papal Masses (including his installation).
There’s my thoughts. Impeach away.