Allow users to configure different sizers for memory queue

[bogdandrutu]

Depends on #12706

[codecov]

Codecov Report

Attention: Patch coverage is 77.77778% with 6 lines in your changes missing coverage. Please review.

Project coverage is 91.52%. Comparing base (58370e5) to head (dbb0244).
Report is 1 commits behind head on main.

Files with missing lines	Patch %	Lines
exporter/exporterhelper/internal/queue_sender.go	40.00%	2 Missing and 1 partial ⚠️
.../exporterhelper/internal/queuebatch/queue_batch.go	86.36%	2 Missing and 1 partial ⚠️

❌ Your patch status has failed because the patch coverage (77.77%) is below the target coverage (95.00%). You can increase the patch coverage or adjust the target coverage.

Additional details and impacted files

@@            Coverage Diff             @@
##             main   #12708      +/-   ##
==========================================
- Coverage   91.54%   91.52%   -0.02%     
==========================================
  Files         480      480              
  Lines       26456    26452       -4     
==========================================
- Hits        24218    24211       -7     
- Misses       1772     1774       +2     
- Partials      466      467       +1     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

[codeboten]

not a blocker, but since there's only one case, do we need a switch here? (same with the switch at 47)