Identified needs do not necessarily need to be met by funding from the local authority no, because for very good reasons the NHS are responsible for some needs, and some needs could be seen to be able to be met by the person themselves or by family and friends. Some people occasionally have needs identified that they are happy not to be met. Any needs identified also have to be 'eligible needs'.
So usually its very easy / clear cut to assess and meet someones physical needs as eligible needs.
But in terms of meeting someones social needs, the local authority could offer day centres etc but these aren't for everyone. Alternatively they could signpost to local groups or charities. Or a person's social needs could be being met perfectly well within their own exsiting family and friends without the need for any further intervention from social services. If social services identify a need but also identify a reasonable way that need can be met without the need for formal services they will. The need will be classed as met even though it is not social services that is meeting it.
Social Services with the best intentions cant meet needs with services that increasingly don't exist sadly. As long as they can reasonably demonstrate how the need can be met they are working within the law, even if the need isnt met in the way the individual would have liked.
An infamous (and quite old) example of this was a woman who wanted carers to come and take her to the toilet during the night in her own home. The local authority said there were no care agencies in the area willing to provide a night time service so her options were she could either use incontinence pads and stay in her own home or they could find her a place in residential care. The woman took the local authority to court and lost as the local authority had identified how they could meet the need.
if its any comfort Its likely that the hospital social worker will be looking to put in enough of a service to get him home in the first place, and then the case will be handed over to the community teams for more in-depth support planning. Its not right, but unfortunately hospital teams are expected to have a fast turn around.
Have the family considered that he will now be eligible for disability related benefits and factored that into any decisions?