IMO there should be no technology in school classrooms until high school. Kids do not need computers to learn K-8 subject matter.
The problem is abuse of the tool, as you describe. In my primary school, we were taught how to use Microsoft Office by using a workbook the computer teacher licensed to the school. We had some of the best computer resources amongst local schools at the time, yet learnt almost nothing about computers. It took me until university to write a line of code.
I understand your sentiment about the opportunity costs for those with computing knowledge, but it wouldn’t be too hard to require teachers to do a basic computing unit at university. In the same way the best mathematicians are not usually school teachers, yet “regular” teachers seem to perform sufficiently.