Would a bad rear main seal leak transmission fluid?

No a rear main seal is the rear seal on the crank shaft of the engine. That portion of the engine is wear the crank shaft connects to the clutch and pressure plate (manual transmission) or where it connects to the torque convertor automatic transmission.