Honestly, I agree that Archbishop Cordileone was inappropriate for the SF area. He would fit a fullthroated conservative area quite well, but he is not very skilled at evangelization, which is what is needed in the SF area.
That being said, I agree with kozlosap that while I believe Pope Francis would have never appointed him there, he will also not remove him, as it would issue the wrong message.
If someone needs a specific example of why Archbishop Cordileone is a bad fit for SF, a good example is his refusal to recognize an orthodox gay or lesbian Catholic group because they refused to stop using the words “gay” and “lesbian.”
ncronline.org/news/spirituality/gay-ministry-group-refuses-sign-oath
Another example is how he declined calls to step down from a parade that was organized and participated in by anti-gay hate groups.
sfgate.com/lgbt/article/S-F-archbishop-March-for-Marriage-is-not-5557050.php
These actions just make gay people feel unwelcome in the Church, which should be a non-starter for an archbishop for San Francisco.
Edit: I want to make clear I am not attacking his character. I am sure he means well for all his parishioners (and all San Franciscans). But his strategies are not a good fit for San Francisco; they are isolating.