I've seen plenty of instances of the same thing - new hires where it was clear he team wasn't a good fit. They had an adult conversation with the current manager and did their best to be productive until they found a team that was a better fit and transferred.

No drama and no hard feelings.