Texas A&M kicker recited Psalm 23:1 all night before hitting game-winning field goal against Alabama