Is this 2002 Kestral Talon worth it?

That is a triathlon bike. It’s fast, but uncomfortable. The important questions are how fit are you, and how long have you been cycling?  If the answer to both is Not Very, then you would be much better off with an endurance bike – something with a more upright and comfortable position.