All jobs based on technology will become obsolete when the technology does. All technology becomes obsolete eventually. So yes, software will replace you... eventually.
In my day, no one expected that. Today, it's pretty much a given that you'll have to keep retraining all of your life to keep up.
Bear in mind that chatgpt was developed before the current "AI" craze. Now, everyone and their brother are dumping money into new language models and I've seen a number of papers claiming to get orders of magnitude more efficiency with newer techniques. AI is likely to grow alarmingly fast, but as I say, you're going to have to keep learning new things anyway, so stay zen and go with the flow.
If you're concerned about whether unity is going to be easier with chatgpt, don't be -- it's already easier (as long as you're willing to pay/search for stock modules) -- that's why it's popular. Adding AI to the mix doesn't really change that.
There's no question that chatgpt is useful, just like wikipedia or reddit are, but it's just another tool at the moment. I haven't been tempted to spend any money on it, and you will have to spend money on it eventually to get the best results. Right now, everyone is scrambling to stake a claim, from artists to lawyers.
My concern is whether there will be useful, free (as in freedom) large language models in the future, when they become mandatory for doing productive work. I'm not sure that the open source model will extend to giant datasets that probably infringe on somebody's copyright. Big companies can buy their way out of that, but not free developers. Of course, free software nuts like me will always be out there tinkering, but maybe AI will make our efforts pointless.
If you're currently making money with the games you build in godot, you want to consider how AI will affect that -- there may be a huge boom of AI-generated games soon that makes it really hard for a small developer to get noticed. But, then again, it's already pretty hard. On the other hand, if you're mostly having fun with godot, just keep doing so.