It's just a saying when someone says such a correctly obvious thing.
Royal Guard: Fuck, we're surrouned by these creatures! News Reporter Who Happened To Tag Along Somehow: No shit sherlock!