When the entire focus is on glorifying evil, no, it is not.
What if the Bible solely focused on the evil works of Satan, the Father of Lies, indulging in exhaustively orgiastic, at times virtually orgasmic, delineation of them, but ended by showing him getting what was coming to him?
Would that be good enough to show us what goodness, mercy and grace is?
I repeat: No, it is not clear enough.
If that's the way you see it, fine. I'm sure your opinion is grounded in a firm moral base and I consider it valid and intellectually honest.
Personally I found The Sopranos to be effective FICTIONAL literature about good or evil, life or death and the consequences of making the wrong choices - throughout the whole thing. I only watched it once, but... Richie Aprile, Ralphie, Uncle Junior, Johnny Sacks(?)... Tony's mom, too, all came to grief at various points along the way, while Christopher, Paulie Walnuts, and Silvio, (whom I rather admired for being a somewhat dapper guy, in his own style, until his true nature as a killer was revealed when he obediently murdered, what was her name, Christopher's young wife...) all met their demise within about, what a couple of days of the moment when Tony and his family [CUT TO BLACK]
SPOILER ALERT: For those who didn't figure it out, when Tony, Carmella, and A.J. took their seats in the big booth in the diner and as Meadow was having a hard time parking her car, remember all those unaccompanied middle-aged men who entered the diner and casually took seats at tactically located spots all around them? One particularly recalls that one of them was wearing a Carhartt work vest and a baseball hat that said "USA", with an American flag on it? Those guys were all hit guys, sent to exterminate what was left of the Soprano crime family.
Tony had it coming for obvious reasons. Carmella had been enabling Tony for at least 20 years. Meadow (she's late but on her way in from the parking lot now, she doesn't know it but her life is about to end) has ultimately used all that smartness she was blessed with to rationalize her dad's pathological life, rather than excel at law school and make the right choices. Young A.J. is not as smart as Meadow but he's smart enough at 18 to actually manipulate his parents out of a new BMW and some other bling, as he courts a high school girl... who BTW elicits the information from him, A.J, about where the whole family can be found, in public, this very evening... so they've all made their choices to follow Tony as the head of the "family"... oh, you still don't know it's all over yet?
Yes, that "Cut to black" was the end of the show and the end of the Sopranos. They don't exist any longer, not in this world. No spinoffs, no epilog, no requiem except maybe by Carmella's priest. They all died in a crossfire, let's say within about one second of one another.
Glorifying evil? To the contrary, IMO it was all about the consequences of evil, in Tony's case, and also of tolerating it, etc, in the case of his "family family".
So sad for them. I'm glad Dr. Melfi had some friends helping her out. She had a close call herself.