Ascending rockets as macroscopic self-propelled Brownian oscillators