Adrian clearly suffers from hubris. In the novel, Manhattan as much as tells him that the scheme won't continue to work - "nothing ever ends."
We don't want
the scheme to work, do we? When I read the novel I was left rooting for Rorshach's "inconvenient truth" to emerge and motivate a resistance movement of terrorists and crazies against Veidt's new order, and I always assumed that Moore was too. It seems to me that ultimately the "viewpoint characters" in the book are Manhattan and Rorshach, whose perceptions of reality and beliefs about justice could not be more unlike one another's.