Yeah this is called post spinal tap headache, its pretty common although it can vary in intensity. It's typically alleviated by caffeine and laying horizontally
I had to lay horizontally for a day until they could patch the hole. When I got to the hospital, I had nothing to eat for a day but I puked bile just from the pain. It can get seriously bad.
Yeah sometimes the hole doesn't close up by itself and they gotta patch it. Sorry you had to go through that, I've seen it and it sucks