Unfortunately, there is no table style which would allow to update quickly the geometric properties of a table. Everything must be done manually.
However, if you can’t resize in one go the table, you can insert it in a landscape page. This is interesting with you 6×9 paper where you could have a 9" inch width instead of 6". And this compares nicely with your original 8" width.
You can change page geometry after any Insert
>More Breaks
>Manual Break
where you can choose the page style in effect after the break. Use Landscape and don’t forget to customize paper format.
Such a landscape will print “sideways” and there is no need to manually rotate the table; it is implicit with landscape orientation.
PS: According to your sample, I see 3 small tables rather than one big table with blank rows inserted. Split this table into 3 smaller tables. They will then print on separate pages and this will be nicer than having a single table with a page break in the middle of it.
Also rather than inserting manually note labels in the table cells, use footnotes. Referencing the same footnote several times is done with cross-references.