This phrase comes from the idea that hands covered with butter will be slippery, making holding on to anything difficult. There was also a dialect sense of ‘unable to handle anything hot’, as if your fingers were made of melting butter. Butterfingers! is often jeeringly shouted at someone who has failed to catch a ball in a game.