I think Obama is an angry man who seeks to be a people pleaser as well as being politically correct that goes along with being a people pleaser. These two characteristics are in conflict within him: being a people pleaser and politically correct that are in conflict with his deep seated anger, resulting in his masochistic self-sabotage.
Hence, the winning smile on the one hand and inviting Rick Warren to give the invocation on the other hand. He perversely knew on some level that there were other less controversial people he could have chosen to give the invocation, but he chose Warren at a time when he told Gay people that he was for their equality.
I think deep down he's a masochist who is manifesting that anger both toward himself and toward others who could be his allies. So, he sabotages Gay people with DADT and his Justice Department's legal brief on DOMA; he gets flack for what Rev. Jeremiah Wright preached so he dissociates himself from his friend and mentor of 20 years; he says he wants to remove troops from Iraq, and not only doesn't he do that but increases troop strength in Afghanistan in a war that we can't possibly win; he talks about "change" and continues to bankrupt this country, assuring rampant inflation, devaluation of the Dollar, risking the Dollar not being reserve currency anymore, etc.
He's one angry man, and that anger is manifested both internally and externally, and will eventually destroy him and his presidency, as well as do irreparable harm to this country.
Now, this anger manifests itself in his masochism by commenting on a situation about which he knows nothing, the Henry Louis Gates incident, which also sabotages himself.
Self-sabotage seems to be part of his life-script, and is, unfortunately, affecting virtually every American, particularly those who placed their hopes in him and in his empty rhetoric.