chore: update repo metadata

[bshaffer]

Add library_type for all packages with .repo-metadata.json. This data was gathered using the following script:

# List all packages with a handwritten component
find . -name *Client.php -depth 3 | grep -v tests | sed 's/\/src\/.*//' | cut -c 3- | sort | uniq > handwritten.txt

# List all packages with Gapic components
find . -name Gapic -type d | cut -c 3- | sed 's/\/src\/.*//' | sort | uniq > generated.txt

# List "Manual" packages
diff handwritten.txt generated.txt | grep '^<' | cut -c 3- > manual.txt

# List "Combo" packages
diff handwritten.txt manual.txt | grep '^<' | cut -c 3- > combo.txt

1. The following have library_type of CORE:
   • Core
   • CommonProtos
2. The following have library_type of GAPIC_MANUAL:
   • BigQuery
   • Storage
3. The following have library_type of GAPIC_COMBO:
   • Bigtable
   • Datastore
   • Debugger
   • Firestore
   • Language
   • Logging
   • PubSub
   • Spanner
   • Speech
   • Trace
   • Translate
   • Vision
4. All the other .repo-metadata.json files have GAPIC_AUTO
5. The following were missing .repo-metadata.json files (I presume was by accident), which have now been added:
   • Channel
   • Retail
   • SecurityPrivateCa