“It’s a strange thing to look back on – they were such difficult, miserable times”: Big Big Train once hated 2002 album Bard. But the dark secret has become a rare gem