SF absolutely needs to build more housing. SF also needs to build taller (more skyscrapers).
I have trouble believing AirBnB helps SF. Anecdotally, I know a few people who rent their places on AirBnB. All live in rent controlled units and effectively re-rent at market rates. One actually reduced hours at his job because income from AirBnB was so lucrative.