The attack on Canterlot was never meant to succeed. How could you harvest love from those that hate you? The true purpose was to harvest magic. And what better way to get magic flying than start a war?