Follow up on release flow

When releasing #8026, the release workflow (agent):

1. doesn't validate Tracking issue.
2. dependency check scripts can use some love. We might also need to refactor dependency checks/test/release gates. e.g., we can centralize some if-gates by packages.
3. release deployment and Rust trust publishing flow is ahead of tracking issue checks. This is a bit confusing to a release manager. We can simplify instructions.
4. we should check license in PRs and master.
5. In addition to source release, ASF also requires other release artifacts including LICENSE and NOTICE.
6. Include binding versions somewhere for easier lookup to validate release version finally.
7. Deployments need some love https://github.com/apache/opendal/deployments/production