Catholic Minority Report pretty much sums up my opinion on how effective a handbook by the Vatican will be to get Catholics to return to confession.
I think that as long as Confession is relegated to a half hour block on Saturday nights as is done in most parishes there will be a lack of people going to confession. Making an appointment when you want to be anonymous, as is your right, does not work.
My main parish has confession before every Mass and there are lines. Another parish I go to just started that practice. When Catholics see other Catholics lining up for confession it certainly brings it up to them and shows that “No it did not go out with Vatican II.”
The lack of preaching on sin certainly has lead to this problem. “God loves you where your at” and all that means you don’t have to do anything like actually repenting. We don’t have to go all “Hellfire and Brimstone”, but certainly the reality of Hell needs to be preached. Our Culture is preaching “I’m OK, You’re OK” 24/7 and it needs to be counteracted when the reality is “I’m a Sinner, You’re a Sinner and we both need to continuously repent.”
Efforts like Archbiship Wuerl’s effort to emphasize confession starting from the bishop down is important.
Regular confession by the Catholic faithful will help to bring about an actual springtime of the Church. All renewal starts with self-renewal and that self-renewal is via the grace of God and the great sacrament of confession is an important component of this.