Living next to tourists is unpleasant and unwanted, and is so because tourists don't really care about anything other than their short-term visit. AirBnB is not correlated with that, AirBnB is a direct facilitator of it.

Allowing people to rent out their apartment doesn't make property more affordable, it allows people to bid up rents with AirBnB income and it prices out people on the margins unable or unwilling to rent out their own home.