Don't feel silly - whenever I smash a finger, I always pass out
You did the right thing in making a hole in the nail plate so the blood could escape. It's the pressure of the build-up of blood that causes all the pain.
Soak it in cold water a couple of times a day, dry it really well and then try to get some peroxide into the space to help dry it out. Do not bandage it because this will allow moisture to build up and you need to keep it dry. Soak it for at least a week, twice a day for about 5-10 minutes each time.
The nail will grow back since you didn't rip it out at the root. Once the nail bed begins to heal, the nail plate will turn loose and you might want to cut it back as far as you can without causing yourself pain. Keep it short until the new nail completely grows in. Depending on which finger it was and your genetics for nail growth, it can take anywhere from 3-6 months for the nail to completely replace itself from the root to the free edge.