Add deployment tests for Cargo and Pip snapshots

[flyingsilverfin]

Problem to Solve

We should mirror the maven snapshot deployment tests, which test whether the deployed snapshot are useable or not.

Proposed Solution

Implement basic tests for Cargo (which deploys a full TypeQL language library) and Pip (which just deploys the grammar library).