This is a phrase used for expressing emotions
A regrettable and unwelcome aspect or feature.
Now it is also used to mean something or someone of untidy appearance.
1.This is a sorry sight to see such wounded hands
2.You seem to be very clever but to me this is a sorry sight.
3.Ramesh is a sorry sight after mining the data from the Internet.