Nearly half of Brit adults think working animals are a thing of the past – but many still play a vital role in the lives of millions of people