To resolve this, I disabled the horizontal spacers that AG Grid adds for pinned sections by applying the following CSS:

.ag-horizontal-left-spacer{
  display: none !important;
}
.ag-horizontal-right-spacer{
  display: none !important;
}

This removed the additional scrollbars under the pinned columns, resulting in a clean layout with only one horizontal scrollbar for the main scrollable area.