Nearly 1,000 historic cathedrals, churches and chapels are at risk of falling into disrepair amid a funding crisis, a charity has warned.