It comes after Rod candidly opened up about how his split from his ex-wife Rachel Hunter (both pictured in 1998) 'tore him to shreds'