Brook will Awaken his fruit in the final arc when all of the straw hat crew dies, and the result will be that all of them become immortal but slowly degenerate into skeletons. In the epilogue, they become a wandering ghost pirate ship and Luffy will be the ghost pirate king!
… and they all make skull jokes!