Ok lots of questions to answer ina very limited time, I'll try and start giving some background first:
1. The no enforcement part:
It's new for Germany and a coincidence: After the election last year CDU and FDP formed the govt coaliton. The FDP (that's the liberals) made the requirement that the law in question will be revoked (it was voted for by the CDU and SPD but not yet signed). However, the president signed the law because didn't see it as unconstitutional and wasn't told not to sign it (the president has very little power in the German constitution, basically just the figurehead to formally sign treaties and laws etc.). So, legally it is now in effect, but actually enforcing it would be against the coalition's agreement. That's very very unlikely.
So I expect it to be formally revoked anytime soon - before the infrastructure to ever enforce it could actually be formed.
Als, there is maybe another misconception in the news about what the law actually does:
What the law allows is replacing DNS entries linking to child porn sites with a link to a "stop sign" that tells users that they were about to enter a child porn site and that that would be illegal. So, going to that "stop sign" is NOT a criminal offense. The whole thing is meant prevent people from accessing child porn, but not to presecute them.
A committee would be formed to determine on a daily basis what site's DNS entries would be replaced with that stop sign link.
A criminal offense would be to circumvent the stop sign by getting to the "forbidden" site by different means (actually very easy but I won't explain here how that works).
So, as the whole re-linking to the stops signs won't be enforced, by the vey definition there also can't be a criminal offense by circumventing the stop signs. - You can't circumvent what's not there.

So there is no "bending the law for politicians".
2.
Hosting snuff sites... Well, that's a hard question. It would really depend on whether it is erotic or pornographic. Not easy to explain the difference in a few words but I'll try:
Pornographic means that the sexual aspects are so much in the foreground to completelyx or almost completely exclude all other aspects AND that is the producers/distributors intention.
So, for example: artistic nude photos would usually not be considered pornographic, but a close up of a pussy would very likely be considered pornographic (unless in a medical journal or whatever). Blatantly showing intercourse would be porn, a short even somewhat explicit sex scene in a 100 minute movie would not make the whole movie pornographic.
If it gets so funny and silly that it is more like a caricature... well, there you have it: if that's the case it obviously does NOT exclude ALL other aspects.
Of course, it is all a matter of perception as is the case with most legal matters. The borderlines are very fluent abd I am (oh what surprise !) more liberal than many others.