fix(storage): destroy local read stream on upload write failure to prevent resource leaks

[thiyaguk09]

Thank you for opening a Pull Request! Before submitting your PR, there are a few things you can do to make sure it goes smoothly:

• Make sure to open an issue as a bug/issue before writing your code! That way we can discuss the change, evaluate designs, and agree on the general idea
• Ensure the tests and linter pass
• Code coverage does not decrease (if any source code was changed)
• Appropriate docs were updated (if necessary)

Fixes #7325

[gemini-code-assist]

Code Review

This pull request ensures that the local readStream is properly destroyed if errors occur during the upload or piping process, and adds a corresponding unit test to verify this behavior. The review feedback highlights a potential resource leak if createWriteStream or progress listener attachment throws an error synchronously before the readStream is piped, and suggests instantiating the readStream after the writable stream is set up.

[Dhriti07]

LGTM, Will add approval once the linter issue is fixed