I wanted to thank @depronman for offering this fix, I have a working light now! It actually took me longer to adjust the bulb holder to make contact with the bulb, because obviously the previously owners had deliberately fiddled with it so it doesn't make contact.
View attachment 73500