Guys like Carlin were funny regardless of whether you bought in to his (real/perceived) iconoclasm and/or rebeliousness. I can remember sitting in the audience watching Carlin - I was working at GE at the time - and leaning over to my boss at the time and saying "He's pretty much making fun of US, but goddamn is he doing a good job of it!".
I LOVED George Carlin. I first heard of him via a borrowed cassette copy of A Place for My Stuff when I was a sophomore in high school (82-83). I went back and heard more of his old stuff and some of the stuff he did later in the 80s. I then went to see him live in October 1991, and I thought it SUCKED. I viewed Carlin as someone whose comedy occasionally hit on political themes, but the guy I saw was a political ranter who was only occasionally funny. I never went back to him after that.
I don't really have any idea who Trevor Noah is. The name is vaguely familiar, but I googled him, and didn't recognize him.
Ninety-one was a weird time for George. Gulf War I really pissed him off a lot. He'd been moving in a more political direction, but that really put him into rant mode. Overall, and through the course of his career, he was just opposed to bullshit. Quite strongly opposed. Which side the bullshit came from wasn't really a consideration. In that case the biggest pile imaginable was stacking up so he was pretty much going 110% at Bush. It was massively anti-republican, and he was as pissed off as you'll ever hear him.
For what it's worth, later in his career (and life) he became more philosophical than political, and definitely less angry. He'd still go on rants about things that pissed him off, but they tended to be more along the lines of what he was doing in the APfMS. Stupid expressions, or irrational beliefs.