Henry Edward Manning (1808–1892), Cardinal