I don't think that I have ever seen a motorised tailstock for drilling. Every example that I have seen used toolpost-mounted drills for feed-per-rev drilling.
Fusion probably can't be persuaded to use Y as it won't believe that Y can be parallel to Z. You _might_ have more luck with the tailstock axis as W (supplementary axis parallel to Z)
That said, the postprocessor is just Java, I would have thought that it was possible to make anything happen in there for specific G-codes.