I empathize totally. All of my snakes were using bulbs at one point so I kept more bulbs on hand than most pet stores. I was keeping low wattage bulbs in the summer, mediums in fall/spring, and high wattage in the winter. I always had multiples of each on hand so I wouldn’t be constantly running to the pet store.
I discovered late in the game that buying a simple table top dimmer switch Would solve those problems. By using high wattage bulbs and dimming them down I got over two years use and counting. I don’t know an exact number because I got away from bulbs. But once I had that dimmer I never burned out another bulb.
As far as bulbs blowing up, that is usually caused by moisture coming in contact with a hot bulb. Could be from a mister, a sneeze, cough, or even a heavy breath.
Oh yeah, these plug in dimmers are only $8-12 at hardware stores or large internet shopping sites.