Children in Need viewers left ‘sobbing’ as McFly star sings with his son during moving performance