Yes, it is extremely rare. As a comparison, the US has about 40,000 deaths from car crashes per year. About 110 deaths per day. Your kid's risk of dying on the drive to school is 10,000% higher than from being shot during the day.
Also, the school shooting statistics grossly misrepresent the real risk for the average family, because distribution is extremely biased towards violence that happens in a tiny number of high schools with high crime, drug and gang problems.
Few things are as emotionally overwhelming as the idea of your child being killed, so people react based on how strongly they feel about the issue, not by rationally assessing the real risk. A Columbine-style random mass shooter is like being afraid of a shark attack at the beach - it strikes terror into people, but it's not factually in the top hundred or thousand things you should rationally be worried about.