> Is the Secret Service really confident that it can protect its charges from this kind of attack?

Yes. Our military is pretty confident that it can handle any form of missile/flying object trying to reach US soil before its an issue, which is part of why we feel pretty much zero repercussions for being terrible.