If I remember correctly, every ship that was offered to Riker found itself blown to varying numbers of pieces soon after it was offered. Staying with Picard was, essentially, survival instinct.That ship they offered him was humorously converted into debris by the Borg at Wolf 359... Am I conflating again?