I assume this is less about an individual retiring as it is about the assumption that something is going on that caused the individual to retire.
These sorts of transitions take time, when you're the CEO of a $75B public company you typically don't up and quit because you see some bad news on the horizon. Especially not when you have such a stellar reputation and are already a billionaire. Slootman didn't need this job.
Snowflake also missed on guidance.
By whom? I used to work at Snowflake, and from what I remember people on the inside were far more excited about the founders than they were about the CEO.
I got the impression that he was meeting expectations for the CEO job, but no more. Though that's a pretty high bar, given position of the company and the industry.