Having read the review, it does look as if the remake will be a lot more 'grown up' than the original.
It looks as if it will be much harder and darker, with some effort to show that not everybody is a warrior and that the Cylons have a greater goal than just the extinction of humans.
To attempt to compare the whole concept to 9/11 or Pearl is, IMHO. misleading. The scale of the tragedy here is much larger, with the overthrow and virtual extinction of a race. Perhaps Dresden would be slightly better?
The will of the people has broken and all we have left is 50,000 survivors selected from many hundreds of thousands of other survivors. It is a sad point that many of those 50,000 will be people who are there for their own salvation.
Whether the remains of the military are in any better state would also be debatable. Morale would be low, in the scenario as has been laid out, with the Galactica being laid up (I've seen battle-hardened Sergeants cry when their Regimental Colours have been laid up!). Then to find their leaders have been so vastly wrong, will break all but the most disciplined troops.
The review gave no detail of how this plot scenario is worked. If it is done well it could well be a powerful drama/adventure as well as the much craved action.
Of course this does not mean the series will be a success. As a drama it will appeal to a much different sect than it did as a light action/adventure?
And of course to work it would have to be done well, which could also be beyond the ability of Mr Moore?