Not for long, though:

Motti’s ambitions, which grew in the wake of the battle station’s completion, were short-lived, however. The Rebel Alliance, who had obtained a copy of the Death Star plans during the Battle of Scarif, discovered a weak spot in the station’s thermal exhaust port and successfully exploited it, leading to the destruction of the battle station along with the deaths of everyone onboard, Motti included.