No.
Bono will not follow Hamilton in Ferrari.
As the media said Bono has been promoted in Merdedes and will not come in Ferrari.
The engineer for Hamilton will be almost for sure Riccardo Adami, who is currently working with Carlo Sainz.
Oh then Hamilton had better get along with Riccardo Adami. But Sainz hasn't had big issues with his race engineer so far. I think there wouldn't be any serious issue. Ferrari isn't losing their best race engineer at least.
RBR still has a chance to improve their car, because this is F1 and anything can happen. So we can't say that McLaren can win the championship and nothing can stop it, it's possible that RBR and Ferrari improve their performance. And talking about Max, yeah he might be disappointed with his team's performance in recent times, but that doesn't make him lose faith in RBR, remember that RBR gave him the best car in 2023, and he still believes that RBR can give him a car like that again. If he wanted, he could have moved to Mercedes who offered him a much better offer than RBR, but he refused and stayed at RBR, that shows how his relationship with RBR is not just a work relationship, but it's like family.
I think Red Bull won't make big difference until the end of the season. Maybe they can save the day in a couple of race with some upgrades. But nothing more I expect.
When it comes to being "family", Max likes to be with Helmut Marko. He has a big respect to him. If he doesn't leave Red Bull in the future, I believe the biggest reason would be this.