stream: make sure _destroy is called on the tail
Fixes: https://github.com/nodejs/node/issues/51987 (attempt to).
Please let me know if I am on the right track as I could be missing some important stuff here. If the fix is on the right track I will add a test.
EDIT: I have added a test.