Fix test failures when run under `colcon test`

[azeey]

🦟 Bug fix

Summary

colcon test wasn't working for me because the LD_LIBRARY_PATH environment variable was being overwritten.

Checklist

• [ ] Signed all commits for DCO
• [ ] Added tests
• [ ] Updated documentation (as needed)
• [ ] Updated migration guide (as needed)
• [ ] Consider updating Python bindings (if the library has them)
• [ ] codecheck passed (See contributing)
• [ ] All tests passed (See test coverage)
• [ ] While waiting for a review on your PR, please help review another open pull request to support the maintainers

Note to maintainers: Remember to use Squash-Merge and edit the commit message to match the pull request summary while retaining Signed-off-by messages.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 87.74%. Comparing base (eac2e69) to head (3bb6be3). Report is 5 commits behind head on gz-transport13.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## gz-transport13 #483 +/- ## ================================================== + Coverage 87.69% 87.74% +0.04% ================================================== Files 59 59 Lines 5704 5710 +6 ================================================== + Hits 5002 5010 +8 + Misses 702 700 -2 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.