I'm pretty sure SFO always has functioning ILS, otherwise the airport would have to close every time there was even mildly bad weather. Each runway has its own system, though, so an individual runway's ILS can be turned off.
If there was fog, they wouldn't have been using 28L.
ILS does not entail automation -- it provides guidance to humans operating the controls.
ILS does not necessarily indicate automation, but about 5% of ILS approaches are autolandings.