CNN reported on Monday more details about the shooter who opened fire and was killed at a Texas megachurch over the weekend