In Quebec it's probably a requirement just for logistical reason. Too many French speaking passengers that you can't afford to have staff who don't speak French. At other airports and other crossing points there are definitely CBSA staff who are not bilingual.