TV give you a skewed idea of Paris Roubaix... you only see those who "survive", you typically don't see what happens at the back of the race and you only see a broken wheel if it happens to Van Aert & Co.
I have done the Cyclo version of Paris-Roubaix twice and it really tests the rider as much as the equipment... I would never use a pair of Lightweights on anything other that decent tarmac... not much because they are or aren't more fragile (I honestly have no idea), but mostly because any damage cannot be fixed at the shop down the road. So then you need a new pair of wheels. Ultimately and maybe controversially, TCR is a very long reliability ride, you set off to do it in 10 days or whatever and try to stick to the plan as much as possible... the name suggests it is about reliability.