A Hereford councillor says a modern church in the city should stay, not be pulled down to make way for a care home.