Hi Mick, just to clarify there are two roof motors, the first in the windshield header to latch/unlatch the top, and the second (the lift motor), to open and close the top. During the opening/closing operation, it is normal for the red light to come on when you press and hold the open or close button. The red light will continue to illuminate until the operation is complete (top fully open or fully closed), at which time the light switches off. This does not necessarily indicate a malfunction but that the top is not fully open (or closed, as the case may be).
The lift pump/motor unit is located down in the bodywork behind the driver's door. If you are hearing that motor run, that is good news, but if you are low on hydraulic fluid you likely have a small leak somewhere, and in order to service it you will first need to extract the unit from the bodywork. Hope this info helps, please post any updates.