Is it possible to capture the output of stderr in Net::OpenSSH to a variable instead of to a file

Not safely.

The master SSH process is run on the background asynchronously. Any module redirecting its ouput to anything but a file may interfere with the module inner workings.