The search for an underground storage site for high-level nuclear waste is likely to go ahead in Cumbria after a poll showed residents are in favour.