This is in the UK so there's not usually a hostile relationship between the police and the general citizenry, so I'm not worried about this coming back on me. The police are already aware that I've been trying to retrieve the footage from Google with limited success so far and I've provided the most relevant sections via mobile phone screen recording.
My main interest in trying to get this footage is that there's been a crime and the person responsible ought to be prosecuted.
I'm planning to let them know that the only way forward may be for them to subpoena Google directly. The likelihood is that they won't be able to get that done in time before the footage expires. Under resourcing, budget cuts, etc. I'm also not sure they have enough evidence to make a subpoena under normal circumstances, but perhaps because I've given them permission, that means it's not relevant?
In any case though, Google Takeout not working is still an issue. Isn't Takeout Google's answer to the legal responsibility to provide the user with data upon request due to GDPR?