To put Alex Kirilloff in context a bit, he's still only 25 years old. In 2019, he was BA's #15 prospect, MLB's #9 prospect, and BP's #39 prospect.
In 2020, he didn't play because of the pandemic.
Through 2021-2022, he kept suffering wrist injuries. He's still that guy who was so highly ranked, it's just a matter of whether he recovers from two years of wrist difficulties. He hasn't "failed" at the MLB level so much as he hasn't gotten runway as a healthy player for a long time.
That's why I'd dislike this trade for the Twins and really like it for the Cubs. I'd bet on Kirilloff for a rental almost every time.