I've had this my whole life, though this popping up on here has made me realise that it hasn't happened in about 6 months. I also get ice pick headaches [0], would be interested to hear if anyone else here gets both.
Yeah, I get an explosion maybe once a year or so. And I get the sudden / short headache (which seems to match the description) very rarely, but almost always on winter mornings while driving up to the snow for skiing.
[0] https://denveruppercervical.com/ophthalmodynia-periodica/