Stockfish: 3585 Elo
"Elo suggested scaling ratings so that a difference of 200 rating points in chess would mean that the stronger player has an expected score (which basically is an expected average score) of approximately 0.75, and the USCF initially aimed for an average club player to have a rating of 1500."
I guess that means that Magnus has expected score of roughly 0.25^((3585 - 2864)/200) = 0.00675 against Stockfish 15, which is basically 1 in 200 games?
Computers are definitely much stronger than humans, but not 3600 better. Magnus would certainly be able to eek out plenty of draws, if not only because white can create "simplified" (as a euphemism for dead) positions in just about any variation if he really wants. And Magnus regularly plays these sort of positions literally at the level of supercomputers.
I'd also add that much of the dominance of computers is not based just on raw ability alone, but more psychological issues. Humans can become tilted, intimidated, frustrated, tired, and so on. One of the last major human vs computer events was Kramnik vs Fritz. Kramnik, in a relatively simple position, ended up blundering mate in 1 with plenty of time on his clock. It's unlikely he would have ever made the same mistake against a human. It's just very difficult to get in the same mindset when playing against a human as when playing against a computer. Chess, in spite of being a game of complete information, is still extremely influenced by psychology.
Instead, you should convert the 0.25 to "odds" form. 0.25 is 1:3 odds, represented by the number 1/3. (1/3)^((3585 - 2864)/200) is about 0.01905 (still in odds form). To convert this back to an expected score you would take 0.01905 / (1 + 0.01905) = 0.0187. So Magnus Carlsen's expected score is 0.0187.
Applying the same method to Stockfish, we have 3:1 odds, which is represented by the number 3. 3^((3585 - 2864)/200) is about 52.48. Converting back to expected score we get 52.48 / (1 + 52.48) = 0.9813. So Stockfish's expected score is 0.9813.
Our sanity check is to add 0.0187 + 0.9813. The result is 1.0, as it should be.
Every game was drawn until Kramnik randomly blundered a trivial mate-in-1 in a simple position. That mistake was undoubtedly driven by psychological reasons. Playing against an engine is nothing like playing against a human and it's difficult if not impossible to put oneself in the proper mindset to play well.
The following games were then also drawn until Kramnik decided to do the chess equivalent (when playing against a computer) of going for a hail mary, with black, in the final game to try to even the match score. Suffice to say, that failed and the match ended as a generally disappointing, for everybody, 4-2.
There have been a variety of gimmicky matches since (fast time controls, various odds matches, etc), but nothing serious.