I had a game recently where a couple of players turned up in trainers, and I've let them play.
For me, it depends on the age, skill level, and type of trainers (all leather vs canvas). Realistically, many boots offer little protection these days, so biggest risk may come from lack of traction...