"Should an amended tax return be filed to claimed in 2023 to account for the excess contribution?"

Earnings attributable to the amount would be reported for every year the excess exists in the account.

It also matters if the contribution was deducted or not.