I think you are overestimating the threat model. Nothing is ever fool proof but Tor does make it extremely difficult to actually identify someone. You are talking about a hypothetical attack vs something that is actually feasible to pull off. Tor is design so that there can be many compromised nodes without to much danger. Tor's popularity as makes it hard to track individuals since there is a lot of traffic.
I think you are overestimating the threat model. Nothing is ever fool proof but Tor does make it extremely difficult to actually identify someone. You are talking about a hypothetical attack vs something that is actually feasible to pull off. Tor is design so that there can be many compromised nodes without to much danger. Tor's popularity as makes it hard to track individuals since there is a lot of traffic.
In the context of bypassing a vpn restriction to watch porn or what have you … yes. You’re absolutely right. They aren’t looking for you.