That isn't a credible argument. We've known how to engineer for seismic risks for a very long time and many dense, tall cities are built on top of faults in seismic risk zones at least as severe as San Francisco without issue.
For example, Tokyo and Seattle. San Francisco even has the advantage of being merely fault adjacent. In cases like Seattle, a major thrust fault runs through the city. It doesn't prevent dense construction.
San Francisco is also 3x less dense than Paris (Paris, France).
SF could add homes for 1.5 million people and still be as livable as Paris, if it wanted to.