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.