Will Perl reset STDERR automatically, and if so, when? How do I reset it explicitly?

Not if you just do *STDERR = *STDOUT. But you can do:

{
    local *STDERR = *STDOUT;
    ... code ...
}
[download]

But if this happens at the end of the program, why does it matter?