Does it means RX series consume more power
Yes.
and dissipate more heat than that of RTX series?
That depends on specific GPU, but Radeon GPUs are known to be hotter running than Nvidia GPUs. Meaning that you'll see higher temps on Radeon than on Nvidia.
Which one is average better in term of TDP and performance?
TDP wise, RTX 4070 Ti Super is better, at 285W.
RX 7900 XTX is worse, at 355W.
Performance wise, on average, with DXR (ray tracing);
On 1080p, RTX 4070 Ti Super delivers ~19 FPS more than RX 7900 XTX
On 2Kp, RTX 4070 Ti Super delivers ~11 FPS more than RX 7900 XTX
On 4K, RTX 4070 Ti Super delivers ~6 FPS more than RX 7900 XTX
Without DXR;
On 1080p, RTX 4070 Ti Super delivers ~8 FPS less than RX 7900 XTX
On 2Kp, RTX 4070 Ti Super delivers ~15 FPS less than RX 7900 XTX
On 4K, RTX 4070 Ti Super delivers ~15 FPS less than RX 7900 XTX
Source:
https://www.tomshardware.com/pc-components/gpus/nvidia-geforce-rtx-4070-ti-super-review
So, when you use DXR (ray tracing), RTX 4070 Ti Super is a bit better.
Without using DXR, RX 7900 XTX is a bit better.
Overall, both GPUs can be considered equal performance wise.
Now, when to factor in power draw as well, then RTX 4070 Ti Super is better, since it consumes less power while delivering the same perfomance as RX 7900 XTX.