The insider added, 'Nothing will be overnight but now that his daughter and his ex-wife have said their things, he is taking it to heart and hopefully it will lead to a change for the better'; Hogan seen with Linda in 2005