Here’s one approach which you may test out:

=let(Σ,tocol(split(choosecols(importxml("https://www.pro-football-reference.com/years/2024","//*[@id='all_rushing']"),3),char(10))),
 filter(substitute(split(regexreplace(Σ,"([a-z])( )([A-Za-z]+d+|d+[a-zA-Z]+|[A-Z])","$1🌀$3")," "),"🌀"," "),regexmatch(Σ,"^d+ ")))

As an alternative, you can get the related data with this script;

function getTable() {
  var url = "https://www.pro-football-reference.com/years/2024/";
 
  try {
    var options = {
        "method" : "GET",
        'headers': {
          'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.5359.172 Safari/537.36 Edg/117.0.2045.43'
        },
        'muteHttpExceptions': true
      };

    var response = UrlFetchApp.fetch(url,options);
    
    if (response.getResponseCode() === 200) {
      var html = response.getContentText();
      html = html.replace(/(rn|n|r)/gm,"");
      
      var tablesMatch = html.match(/<tbody(.*?)</tbody>/gm);
      
      if (tablesMatch && tablesMatch.length > 1) {
        var myTable = tablesMatch[2];
        //Logger.log(myTable);
        var doc = XmlService.parse(myTable); 
      
        var rows = doc.getDescendants().filter(function(c) {
          var element = c.asElement();
          return element && element.getName() == "tr";
        });

        var data = rows.slice(0).map(function(row) {
          return row.getChildren("td").map(function(cell) {
            return cell.getValue();
          });
        });

        Logger.log(data); 
        
        SpreadsheetApp.getActiveSheet().clearContents()

        var headers=[['Tm','G','Att','Yds','TD','Lng','Y/A','Y/G','Fmb','EXP']];

        SpreadsheetApp.getActiveSheet().getRange(1,1, headers.length, headers[0].length).setValues(headers).setFontWeight("bold");

        SpreadsheetApp.getActiveSheet().getRange(2, 1, data.length, data[0].length).setValues(data);

        } else {
          Browser.msgBox("No tables found");
        } 
      } else {
        Browser.msgBox( "Error: Cannot connect to URL . HTTP response code: " + response.getResponseCode());
        } 
      }
      catch (e) {
        Browser.msgBox(e);
        return;   
      }
}

.

The below table shows the output on the sheet;

.