I am not sure how significant this is. RNA is basically a single strand of DNA. There is a slight difference in the chemicals but they contain identical information.

If the RNA turns itself into DNA then for it to have an effect on the cell or the person wouldn't it also need to insert itself back into tha main source of DNA in the nucleus?

Analogy: In photographic terms, DNA is like having both a positive and a negative of every picture. From either one you can make the other. To get the cell making some new proteins a copy of the relevant part of that DNA needs to be sent as a message to the cell's workshop. That is what Messenger RNA is for (mRNA).

Even if that copy could turn itself into a fully-fledged positive/negative pair, how can it reinsert itself back into the master plan? That is the part I am missing.

In the analogy, you might be able to reform the original positive and negative but what is the mechsanism for reinserting that picture back into the photo album?