Yes, it's horribly hard for the Queen. It is, of course, also yet another threat to the stability of the monarchy. I only hope that this is finished with before her Jubilee. Hark at me! I'm not really a monarchist, but I do think that, on balance, it is better to have them than not. Right now I would defend the Queen to the end.
Andrew wasn't the only brother to serve militarily, I think. Didn't Prince Charles captain a ship in the Cod Wars? Anyway, the regiments he was associated with will be very happy to lose him.
Speaking as a Yorkshirewoman -- is there any way to stop him being Duke of York?