What makes me very sceptical about the titanium hammers is the fact that they're only really advertised in the USA. For example, you can't find a german pattern framing hammer in titanium (the latthammer).
The 2023 Red Dot design award was in fact given to Picard for their AluTec Latthammer. It combined a steel head with a cast alloy handle.
Picard actually gives insight of why they did not use titanium. Here is my translation from their German text under their youtube video:

Now I am sure there is something to titanium too. But a HUGE part of it is marketing. I think most of us here are tool enthusiasts - and it does not take much to look through the history of almost any tool and see plenty of variations. There are usually pros and cons to every decision. I do believe the titanium hammers are extremely pricey and not worth it compared to other high quality choices, even if they're nice hammers. I am sure something like this Picard is at least very comparable if not even more pleasant to use.
The numbers people say, about absorbing vibrations and transmitting forces... I think those were all spread by the hammer manufacturers. Those numbers are very very hard to measure, and depend A LOT on the actual hammer shape and design rather than solely on the material.
Honestly, as an engineer I feel Picards claims about fatigue are weird too. Not so sure about the fatigue of titanium though surely the softer metal won't last as long as steel, but I do know that aluminium generally does not have very favourable fatigue life. Still, I'm sure it's a fine hammer and that line was more marketing talk to counter why they don't use titanium - in my opinion, it just isn't needed.
But TITANIUM sure sounds nice and people love to buy into that. It is still not a miracle metal. Steel is actually more unique cause it comes in so many countless variations and bonds with so many elements. It is not "just steel". You have so many variations of it that it is really hard to say that any titanium hammer head will perform better than any steel head. It most likely won't.