Pay off wizard

Yes, the title describes me. I have to play better than this if I want to keep playing in the big game.

hand #1
live $100/$200 LHE, 10 handed
preflop: Hero raises UTG w KsKd, loose player (LP) calls, relative-newbie (RN) calls, muck, tight but tricky player (TP) calls, muck, muck, solid button calls, loose and bad SB calls, BB mucks (6 players, pot size 13 small bets)
flop: Qs9h6s, check, Hero bets, muck, RN calls, TP calls, muck, muck (3 players, pot size 16 small bets)
turn: Qs9h6s7c, Hero checks, RN bets, TP raises, Hero 3 bets, RN calls, TP calls (3 players, pot size 17 big bets)
river: Qs9h6s7c4s, Hero bets, RN calls, TP raises, Hero throws up and calls, RN mucks. TP tables As8s

The moment that TP raised the river, I immediately recognized what had happened on the turn. TP semi-bluff raised his A high to buy 2 outs in a big pot against my apparent AK. Despite "knowing" this I paid off to see the hand anyways.

When the spade came, I was supremely confident that RN was not on the flush draw, and I fell into the trap that TP had a top pair type hand. I really didn't think the hand through since TP will not call on the turn with a top pair/no redraw type hand in the face of such a strong turn 3 bet check raise from the preflop/flop leader.