The drummer for the band Cake -- who recently stood trial for child molestation -- is getting some serious support from his soon-to-be ex-wife ... who claims she trusts the guy around their young kids. As we previously reported, Peter McNeal was…