'His overdose was ignited by the pain of Father's Day because he loved his dad more than anything on earth and he was the only person who he felt he could trust,' our insider said (Cher pictured with eldest son - now Chaz Bono - and Elijah in 1981)