What does it mean if he says he loves his kids and his wife is a good friend?

It means he thinks of his wife in not a loving way but a friend way. He might be having second thoughts of his marriage between his wife and him, or he might be cheating on his wife. Usually, he is having second thoughts of marrying his wife.