No
shit sherlock is used to insult someone who is stating to blatant obvious. similar to "you don't say" or "thanks captain obvious!"
if someone is saying
something obvious instead of saying "no fucking
shit" you would add "sherlock" to it just to insult them further.