The Trump-backed Republican, who has been rocked by public scandal in recent weeks, skipped out on a vote on September 25, shortly before the deadly storm arrived in the state