[Bullet Magnet]

Dead bodies float after sufficient putrefaction has filled the abdominal cavity with gas. It's not a magic alive/dead switch. Human beings are generally positively buoyant unless their muscle mass is higher than usual, though clothing and filling the lungs can cause sinking.

But as we know Aerith isn't human. I have no idea what her natural buoyancy is.