I believe you are correct, Mahomes will not get the blame if the Chiefs lose, the coach will.
I think it really depends on how they lose. If Mahomes goes out there and turns the ball over 3+ times it may be tough to blame Andy instead of Mahomes. Any other scenario and you are correct, the blame will go on Andy (whether it is justified or not).