If Google were serious they should have brought out Bruces company Counterpane and put him in charge of security.
Its blindingly obvious to any one with even a basic knowledge of computer security best practice.
Security is hard, and it is even harder when any device on the internet is intended to be able to work with the system, and it is even harder when you operate one of the most valuable networks in the world.
And systems used by your TLA's to handle law enforcement access are not available to "any device on the internet"
As I said they should be set up to only talk over a private circuit to one other end point and also have proper hardware crypto gear that is external to the systems.
separating the extraction of data and applying the decoding probably should have been done on separate systems.
I do not disagree with your overall assessment, but this is not strictly true. Most good real-world security schemes don't follow the 'root is God'-model of Unix, and for good reason. It's perfectly possible to design a system where each operation performed by a "superuser" must be validated, or at least logged.