It's a good idea to and a little goes a long way, but corrosion problems only manifest them if your bike is often exposed to water. Even then, it takes many many years for waterproof connectors to start corroding.
It's more messy than anything, but will make your electrical connectors last longer. By how much? No clue.