There are two cases and they are handled differently;
Before tax due date (including extensions)
after tax due date (including extensions);
----
return of excess contribution:
before tax filing date including extension: positive earnings allocable to the excess are included in income on 1040 Line 4b for the year of the contribution. negative earnings are ignored; in any case, for purposes of basis, consider the original requested amount as returned.
Note: You must have a) filed by tax day, or b) requested an extension of time to file by tax day to take advantage of the Oct 15 deadline.
positive earnings removed are no longer penalized 10% if you are under age 59 1/2. (eliminated in 2023)
after tax due date including extensions: you distribute the excess amount being carried forward on 5329,
(or offset it with currently allowed contribution) .
An amended return may be needed supplying that Form 5329 since there is a 6% penalty per year on accumulating excess contributions .
Earnings stay in the Roth account.
Consult your custodian to obtain the correct removal form for each case.
--
you probably used the incorrect form or your broker did not understand what you wanted.
If tax withholding is shown on a 2024 1099-R code "P" you would get that tax back by amending 2023 tax return.
Generally tax is not withheld because your contribution is not taxable when returned.
