Yes, you have to ask yourself, what would you accomplish by talking to his new GF? Are you just trying to punish him? (Which may be fair, or not, but either way, what does it accomplish?( Are you trying to punish her? (Which may be unfair, and even if not, how does it make your life better to yell at someone else?). Are you trying to torture yourself? If she says, "yes, we've been having wild sex for years," will you be happy?
As for telling your children, DON'T. Even if they are adults, do not make them choose sides. It is fine to say "I am feeling hurt and betrayed by your dad" but leave it at that!
And honestly, People do change, and marriage is not a life sentence. I know it is painful for you to have such a long marriage end, but... these things happen. You probably bear some responsibility too for your marriage not being very happy.
But regardless, have some self-respect. Your DH does not want to be married to you anymore! Okay. His loss.
As your sister says, move on with grace and dignity. If he's a bastard, your kids and his new GF will eventually figure it out for themselves.