Noel-
The car-engine stand should take the weight of a model locomotive but the locomotive will not take being cantilevered from just one end. Structurally, a car engine is a massive, rigid box so will cope with such treatment.
One potential answer, at some cost of accessibility, is to fit the stand with strongly-braced cantilever brackets whose outer ends are equipped to hold the respective buffer-beam
The worm-drive as you suggest is the ideal way to control a rotating stand and I think many such stands with worm-gears have been built. The ratio is not very important, but should be reasonably high.
JA –
My own club still has the thick plywood end-plates for just such a roll-over stand, made for a 7¼” g. tank-loco I think.
I don’t know when it was made, nor whether it was inspired by a published example as yours was, or the brain-child of one of our members
However I would suggest giving it longitudinal tie-rods – M16 or M19 studding on ours I think – linking the apices to resist any tendency for the discs to rotate relatively to each other or out of parallel, and twist the engine chassis.
The loco frame will try to act as a tie, but it is not designed for such an unfair load.