He will retire after reaching this objective and might be at 1007. Remember my words unless some serious problem happened like health or familial issues that broke everything for him, otherwise I am confident that this is an objective for him that might be harder to achieve in top European leagues.
I doubt he will say such thing in public to avoid being criticised by some media and people. Cristiano Ronaldo is an ambitious guy and he enjoyed beating Pele achievement as top scorer and since his rival Messi continues playing, he will try to keep some distance from him in terms of goals to stay always first.
If we look at Ronaldo statistics in scoring goals in the last 5 seasons, the numbers you mentioned are very reasonable. Ronaldo was able to score at least 30 goals in 4 of the 5 seasons he played. The lowest was when he joined Al-Nassr in his first season, scoring 17 goals. If he does not suffer a long injury next season and the following season, his potential is still there, we will se maybe we can see the only one who reaches 1000 goals for his football career. Maybe, we will not meet another players able to break Ronaldo record for the next 10 seasons.