Bacharach could make anyone's teardrops fall, but his material is drained of pathos in this project, says Dominic Cavendish