Oh dear @Kerry26 ! I don't want to sound unsympathetic, but it seems you took a booking outside the terms and conditions for Airbnb, which may be why they are not covering you? (Though it would be good if they would explain this!)
1) Third party bookings are not allowed. - That is to say, well you CAN choose who you let into your house, but the Host Guarantee does not cover you unless the person who made the booking/holds the Airbnb account is present on the trip.
2) Airbnbs are for RESIDENTIAL stays, not commercial.
It's easy to be wise after the event, but savvy hosts tend to DECLINE requests such as you got, from a large group from a film company. Many hosts see such requests as a 'red flag'.
Sadly, many hosts naively think any Airbnb booking is somehow 'safe' because Airbnb has allowed it... That is not true, Airbnb allow anyone to book, with the possible exception of those who appear on a database for the worst kinds of crimes, but an allowed booking is never a guarantee that a guest or their party will not trash your house, sadly. Hosts have to be proactive in screening guests themselves, and checking the property with webcams or visits.
This CC is chock-a-block with stories just like yours..... type words like 'party' or 'trashed' or 'damage' & 'host guarantee' into the search feature up top.