A snake-handling pastor who appeared on a television reality show has died after being bitten during a weekend church service in Kentucky.