0
'Shooting ones Self in the foot' means that you have brought it upon yourself. No one else 'shot' you in the foot, it was you who did it.
It means to make a situation worse by doing something that you really didn't have to do.
Left foot
I don't know if he shot a big foot but he definitively didn't shoot Big Foot, the creature!
with your foot...