As in, is there something NoScript should be doing specifically, that it might not be doing, or is it simply a general issue (that if fixed would result in [far] less sized files)?
Bugzilla: Bug 1813330 storage-sync-v2.sqlite-wal extension data never cleaned up
Each colored band, with exception, is an individual Profile.
The file dated 2024 is my current 115 ESR (uptime since 12/19/2023 & counting).
That 18 MB file is (most likely) from FF versions up to 115 ESR (when I most likely stopped using that Profile altogether).

Extensions:
NoScript
uBlock Origin
Firefox Color
Download Grab (which I didn't even recall that I had it installed)
(Without being scientific in any way, & without opening an sqlite GUI or sqlite.exe) I'm guess that the ONLY data in that file is repeated items relating to NoScript.

If I compress storage-sync-v2.sqlite-wal, it's size drops from 13 MB to 200 KB (so there is LOTS of repeatable data there).
ZIP 0 storage-sync-v2.sqlite-wal -> 0.zip = 200 KB