It is clear that having such a father will be easier for him to move up the career ladder, but only up to a certain point, forever he will not be able to promote him, especially if he does not realise himself as a footballer, so you can end up without starting a career
The question whether the son wants to be a football doesn't really arise I think. Not that he would be forced to by his father, but from what I can see and what Ronaldo talks about him, It is quite obvious that his plan is to pursue a career as a professional football. It also makes sense, doesn't it? If your whole life is about football due to the career of your father and you are also talented and deep in love with football, it is almost inevitable that you give it a try and see how far you can get. But it is true that having a father like Ronaldo is not enough to become and also remain a professional footballer for a long time. I assume he would probably want to be a striker as well and then it's quite simple to see whether he stands the test or not. He either scores a lot of goals or he doesn't.
It's worth mentioning that Ronaldo also said that his son has poor discipline, that it could prevent him from becoming a professional footballer. Maybe it's just because he's still a kid and then as he gets older he'll take it more seriously, so it's too early to tell if he'll have a career or not