if you use a twist flourescent bulb which is not to be enclosed in an
enclosed fixture it will overheat and fail.
also, with the switch off and rubber gloves and a plastic spoon handle
bent the center tab of the socket up a bit to make a better connection
to the base of the bulb.
also you may have a bad switch.
try a working conventional filament bulb awhile to help narrow down the
problem.