Analysis of data over almost a decade suggested fewer adults are getting help from councils in England despite a rise in requests.