Well I would agree that badly played plastic recorders taught by an untrained primary teacher to a bunch of uninterested 7 year olds is hell and is one of the reasons why the recorder as an instrument is majorly unregarded.
I suppose one of the reasons why it was chosen as an instrument to teach in schools is because it is relatively easy to get a sound out of (even an awful screech) and is cheap and pretty much indestructible. I was fortunate in that my recorder teacher at school was a wind teacher who knew what they were doing (but this was back in NZ in the 70s, so very different now).
I am now a big fan of the ukulele which is being used a lot in schools in NZ, instead of the recorder. Much easier to play than the guitar - only four strings and you can play a C chord with just one finger - lighter, smaller and with nylon strings so they don't hurt small fingers so much. Although I expect this, in the hands of an unskilled teacher, will produce as many technical problems as the recorder!
Maybe the real issue is that music in schools is generally under-rated and is sometimes taught by unskilled people with the best possible intentions.