If you are all thumbs, you are very clumsy and you keep dropping things. Your hands fail to do their job properly. You might be suffering from nerves or fear or you might just be very tired.
I was all thumbs when I was paying for my shopping and I dropped my money everywhere.