Then maybe you should sit this one out.
That’s just plain wrong. Thousands of people racing middle and long distance triathlons each year prove otherwise. The weight distribution in aero position should make the ride even more comfortable than a road position. If one’s aero position is uncomfortable, one’s bike is not fitted well.