I tried to get this to work a few months ago and failed as well. Granted I had a 2-3cm hole in my tire. It kinda worked when I rotated the tire so that the hole was at the bottom... But the hole was just too big for the foam.
The tow truck guy told me those kits only work with tiny nicks.