Update 2220 01 May: It's official. They're reporting that it was a SEAL Team that carried out the operation; if so, I'm glad the Navy did it. While they'll probably never be able to publicly announce the name of the SEAL who did the deed, I'm guessing that he'll never need to buy his own drinks for the rest of his life.
I'm glad we shot him, vice killed him with a bomb. It seems more personal that way.
For those who didn't see the President's announcement, here's a link.
Update 0006 02 May: This guy unknowingly Tweeted the attack on the Bin Laden mansion. As far as "what happens next", lots of people are worried about al Qaeda retaliation. It could happen, but it's not like they haven't been trying their best to attack us for the last 10+ years. I'm guessing that if anything does go down, it'll be missions they have in place being launched before they're supposed to be, with concomitant reductions in efficiency. As far as U.S. public opinion, I expect a drop in support for staying in Afghanistan; a lot of people will say, "Well, we got what we came for." And the next time President Karzai whines about the way our military does its job, I would support the President if he were to say, "Fine, we'll leave, I guess you can take care of yourself. And, by the way, you should leave a note to your successor that if we're ever attacked by a group based in Afghanistan again, we won't send in ground troops next time; it'll all be from the air, and not precision-guided, either. B-52s."