While this interpretation seems sound, I think for most people ‘to be honest’ is analogous to ‘now that I think about it more deeply’. I get the impression that people tend to use the phrase when they’re reflecting on, questioning or refining their own beliefs.