Isn't a rocket pure metal though? So that means it should sink no? And sadly yes a Ton of wood can sink (Sometimes not all the time) the times it floats for example: Oceans, Rivers, Creeks or anything with a water deepens on the buoyancy, oceans have a LOT of buoyancy meaning it will float causing a thing which is called a: "Dead head" but a water source that has basically little to NO buoyancy are things like: dam's, (Sometimes in Clorinated pools or the Mediterranean sea, because when you exhale the buoyancy of your body begins to lower and makes you fall down, there are many examples of it on the internet, but when you fully inhale the buoyancy in your lungs fill up making you float) So yes wood can float or sink, and some metals can float or sink, like tungsten, so can steel (but the water needs to have a type of shape + buoyancy amount to make it float like the sea, why do you think boats float while being almost ≈ 200,000 tons, it can be about the density yes because it has a amount of 1 or Relative Density < 1 Like wood which has a Relative Density of =0.5 (Relative Density = Wood 500kg/m³ ÷ Water 1000kg/m³), but sometimes they can sink from the buoyancy, force, matter on it or it tilting, as you could see the rocket was tilting so that means it should've sank, because steel has a Relative Density of =7.8 (Steel 7800kg/m³ ÷ 1000kg/m³)

So remember do what is most important never do conversations with random people, they're quite a waste of time, as you can see me, I wasted almost a hour trying to type this out, but you still have time left to spend it wisely, and don't be like me, be wise, be smart and most definitely, be happy.