Use scripts, How to find out tables that it doesn't span 2 pages (or 2 columns) .

Alright - maybe something like this

Before running the script on a large or important document, test it on a smaller sample file to ensure it works as expected. Save a backup of your document as a precaution.

This is just and idea, maybe it does what you want and maybe not, but hopefully it can be refined or used as foundation going forward.

// Loop through all tables in the active document
var tables = app.activeDocument.stories.everyItem().tables.everyItem().getElements();
for (var i = 0; i < tables.length; i++) {
    var table = tables[i];

    try {
        // Get the first and last rows of the table
        var firstRow = table.rows[0];
        var lastRow = table.rows[table.rows.length - 1];

        // Get the parent text frames of the first and last rows
        var firstRowFrame = firstRow.cells[0].texts[0].parentTextFrames[0];
        var lastRowFrame = lastRow.cells[0].texts[0].parentTextFrames[0];

        // Check if the table spans multiple frames
        if (firstRowFrame === lastRowFrame) {
            // The table does NOT span multiple pages or columns
            table.skipFirstHeader = false; // Disable "Skip Header Row on Page 1"
            $.writeln("Table adjusted: " + table.id); // Log adjusted table IDs
        }
    } catch (e) {
        $.writeln("Error processing table ID " + table.id + ": " + e.message);
    }
}

alert("Script completed. Tables that didn't span pages/columns have been adjusted.");