Well not exactly. If the AirBNB host is a tenant themselves, then the subtenant relationship will end when the AirBNB host vacates the property.
Not all SF landlords are opposed to their tenants rerenting the units on AirBNB. Some even deliberately rent for minimums of 30 days, to avoid running into zoning regulations against short term stays. AirBNB promised to start collecting hotel taxes in SF, but such taxes wouldn't apply in this case either.
That is not entirely accurate. If you were renting a room in a apartment (you being the master tenant) and you still resided in the apartment in another bedroom AND also showed/informed the new tenant a copy of San Francisco Rules & Regulations 6.15C- then yes, you could evict them.
Otherwise, you cant- and the tenant takes over the defacto 'lease' from you.
Costa Hawkins (which I believe you are referring to) is a landlord/owner option. You as a tenant cannot initiate it and would be shit out of luck. You might be able to get your landlord to initiate the lawsuit for you, but I doubt they want to come out of pocket on legal expenses on your behalf.
Not all SF landlords are opposed to their tenants rerenting the units on AirBNB. Some even deliberately rent for minimums of 30 days, to avoid running into zoning regulations against short term stays. AirBNB promised to start collecting hotel taxes in SF, but such taxes wouldn't apply in this case either.