You do realize that the trans. shifts into OD around 45, right? Probably why the rpm's drop. Try leaving the shifter in "3" instead of "D" and drive at 45 and see if the rpms drop. If they don't then shift it into "D" and see what it reads.

And yea, get the codes scanned. We're not good at guessing games for CEL's, lol...