Patrick Cockburn: The story of the Spey is eye-opening and worrying – but there is still reason to be hopeful