Electrical mystery.....

Easy, the socket is bad....

Dam, cant believe you missed that....

I’ve also had it where the spring in the bottom of the socket gets weak or breaks and the contacts won’t contact the bulb