I've never scotch guarded a car, and never had a stain that couldn't be taken out with my carpet shampooer. But I don't have kids, and its not like I'm spilling double-gulps all over the place.
If you think you need it, it couldn't hurt to buy a can and spray it down. I think everyone should think about it if they have the light colored interior, that looks like it would show everything.