Pretty much guarantee your hole is too big. Get one of mom's sewing needles and just dimple through some foil, small as you can get.
Of course, this will be of no help whatsoever if there is a light leak. Or the room where you load the film has a light leak. Or if the film itself has been exposed.
I would first make sure there is no light leak. Process a frame unexposed, see what you get. Second, make a tiny hole in foil (or better, metal from pop can) and try again.