It means when someone gives you a lot of warnings about doing something bad that they seldom follow through with their threats.
What Is The Meaning Of "Barking Dog Seldom Bites"?