I think the Madone Speed or the new aero bars from that upgrade (presumably what your mentioned) are a fine option, IMHO.
People add clip-on areo bars to roadies to make them fit a range of uses. Comfort and getting weight of the hands is a great one too.
Do keep in mind the setup in a road application can and does often vary from a typical aero TT or Tri setup. Placement needs to be relative to a more road based saddle position, unless you plan to set up a more mixed position.
But for a comfort based layout, you just end up with a more rearward biased aero bar and possibly a bit higher too.
I think it’s very worth consideration and suggest ignoring clip-on detractors that tend to be overly fashion centric.