Even with the current 12 core machines the CPUs are the limiting factor, not the hard disc that is written to.
So it doesn't make any difference in terms of performance if you let handbrake write to a mechanical or flash disc.
Considering, however, that SSDs have limited write cycles I'd suggest you choose the HDD for your handbrake output.