Eight years into the war, the U.S. intelligence community is only "marginally relevant" to the overall mission in Afghanistan, a new report says.