Football coach who prayed on field resigns after Supreme Court victory, cites family and advocacy