The high price of housing in San Francisco is caused by one (and only one) thing: NIMBYism.
If supply is constrained and new high-rise developments are held back, there will always be higher prices and a distorted market.
In reality, Airbnb doesn't have any measurable effect on the price of housing. (Still, it may help alleviate the situation slightly for some people living in the city.)