I enjoyed the article, and I'm actually, surprisingly, fairly convinced by his idea there is something off about things like the imaginary philosophical zombie[1].
I think that the idea of a soul or spirit could be both interesting and also self evident though, so it's odd to read these being thrown out in the same bath water.
I.e if we imagine our simplified brains as points of matter with signals being sent between; then the kind of experience we have as human beings is more about the relationships between the matter. I don't see that as a harmful duality as if it were the case, it would shed light on what we understand and how. We're still physical but exist in "spirit of matter", different but bound. No magic required.
I'd see this as fairly separate from the question of why we witness ourselves, which seems more prone to mental trickery.
Rovelli also has some fun popsci book on how Time might be constructed. Mostly a fun read but the theories, when he gets to them, are an interesting take. Highly recommend.
[1] However if Carlo Rovelli were a philosophical zombie, are these exactly the responses he would give - as it wouldn't "see" the moment of awareness and be confused by implied significance? I think so.