Britney Spears is said to be "very sorry" following her DUI arrest on Wednesday and is worried about letting her millions of fans down as the incident plays out