Can I drop multiple Destination tables in a Pipeline at once?

No, you can delete only one Destination table at a time. Auto Mapping must be disabled for the Source object (Event Type) mapped to the table that you want to drop. Read Deleting a Destination table.