The cinematic duet appears on Lambert's Seventies-inspired album Crisco