Fix CI pipeline test
    
    - Move from the deprecated standard-test-scripts to the better
      supported standard-test-basic. This can install test dependencies.
    - Drop the obsolete standard-test-overlay, it does not even exist any
      more.
    - Drop test-canary. This was being used to test the CI gating, but this
      has been done now.