I am not sure when is appropriate to use the phrase
"That's a shame"
or
"That's a real shame..."
Is it friendly? Respectful? Is it a thing very close friends or people say to each other when they want to imply the other person has not done a good job(and hence he should feel shame?)
If you can help with appropriate contexts and kind of people we can say this to that'd very helpful.