After an incredible front row qualifying, it didn't turn out to be the dream weekend many local fans wanted from their hometown hero