I don't think it's fair to say that SF "flops" on public transit. Look at the map. LA, Houston, Dallas, and Philadelphia are public transit flops. San Francisco is merely mediocre.

And (as pointed out), this is during the BART strike. I fully expect SF's transit system will be considered "good" once everything's settled.