It means "unfortunately".

more's the pity what does that phrase mean?

Your phrase is adverbial and means the same as "unfortunately".

For instance:

Did you pass the test?
More's the pity!, I flunked!