What could cause ceiling fan lights to flicker on with power and then go out immediately?
I've seen this happen before.  The vibration of the fan loosens connections to the bulbs.  The lighting portion of the fan should be removed and examined for flaky connections.

The fact that the lights come on and then off might indicate an issue with a partially-inhibited connection that is generating some heat and then separating somewhere in the light fixture.