If you're shooting in low light areas, then yes it will help.
If you're shooting in pitch black areas, no it won't really help since you can't see what you're shooting at.
If you have a weapon-mounted light underneath the frame, no the night sights will not help as the light will over power the tritium inserts and you'll basically just see "black posts" as your sights.
If it's dark and you hear a bump in the night and need to grab your gun from your nightstand, yes the night sights will help as you can clearly see them glowing, thus telling you where the gun is located at and how it's oriented/positioned.
Those are the main things that come to mind when I think of night sights. That being said, I like them on all of my guns since I find more advantages having them.