I can’t imagine Apple and Google would work together to integrate Google Assistant in Apple’s systems in a way that meets Apple’s privacy standards.

I think if Siri got direct web answers working reliably (currently being tested in Spotlight search) then the two assistants would be comparably useful.