As mentioned the difference between max TT weight and max tire rating is on the tongue. It is the same with the axels, my TT has a gross weight 7500 lbs. the two axels are only rated for 3500 lbs. each.
Million of "C" rated tire have been put on TTs every year for decades. They will continue to be put on TT for decades to come. They are used because they work for most TT applications. My C rated tires were rated 140 lbs. over the axel rating.
After 7 years and over 18,000 miles of towing with the original C rated tires I went to D rated tires, because it allows some latitude on tire pressure. My tires are rated C at 50 psi and rated D at 65psi. They are also several hundred lbs. over the axel rating at their D rated pressure.
So, when I was in Texas at 80 degrees and the tires were at 65 psi cold, I did not have to worry that three days later in Flagstaff waking up to 4 inches of snow and temps in the high 20's that my change in tire pressure would be an issue. Especially since two day later I was in Phoenix in the 90's.
A person certainly can and some do, spend the money to upgrade their tires. The RV industry and the majority of the RV owner will not. The same can be said for P rated tires on pick-ups.
It is basically the individuals choice.