While I'm certainly no prig, and have been known to use salty language in select company, I also think there is a boundary of propriety between public statements or interview answers and being mistakenly being caught off guard. This clearly crossed that boundary. While it's not necessarily abject profanity, it erodes the dignity that should be part of the presidency and rings paricularly hollow given the profound lack of meaningful action taken by the president during this crisis.
"Ass kicking" won't solve the problem; leadership, and a credible course of action will. This well has been gushing oil for going on two months, and the administration still seems to be in a quandry as to what course to take - this is simply unacceptable.