Mr. Looney, a longtime BP employee who was named chief executive in 2020, agreed to step down immediately, the board said.