So, as it's main competition will be Skarmory let's check what this weird rocket bamboo thing has going on for it.
Calcs only for damage reference, I'm not stating that Steela
(you heard it here first) counters or checks these mons. Btw I forgot to set the mons to lvl 100, so all these calcs are considering lvl 50.
Physically defensive:
Hide
252+ Atk Mega Heracross Close Combat vs. 252 HP / 252+ Def Celesteela: 103-123 (50.4 - 60.2%) -- guaranteed 2HKO
252+ Atk Mega Heracross Close Combat vs. 252 HP / 252+ Def Skarmory: 84-100 (48.8 - 58.1%) -- 96.9% chance to 2HKO
252 SpA Choice Specs Keldeo Hydro Pump vs. 252 HP / 0 SpD Celesteela: 139-165 (68.1 - 80.8%) -- guaranteed 2HKO
252 SpA Choice Specs Keldeo Hydro Pump vs. 252 HP / 0 SpD Skarmory: 186-220 (108.1 - 127.9%) -- guaranteed OHKO
Specially defensive:
Hide
252 Atk Mega Heracross Close Combat vs. 252 HP / 0 Def Celesteela: 130-154 (63.7 - 75.4%) -- guaranteed 2HKO
252 Atk Mega Heracross Close Combat vs. 252 HP / 0 Def Skarmory: 102-120 (59.3 - 69.7%) -- guaranteed 2HKO
252 SpA Choice Specs Keldeo Hydro Pump vs. 252 HP / 252+ SpD Celesteela: 102-120 (50 - 58.8%) -- guaranteed 2HKO
252 SpA Choice Specs Keldeo Hydro Pump vs. 252 HP / 252+ SpD Skarmory: 126-148 (73.2 - 86%) -- guaranteed 2HKO
Offensive presence (Steel and Flying moves):
Hide
0 Atk Celesteela Heavy Slam (120 BP) vs. 0 HP / 0 Def Mew: 69-82 (39.4 - 46.8%) -- guaranteed 3HKO
0 SpA Celesteela Air Slash vs. 0 HP / 0 SpD Mew: 45-54 (25.7 - 30.8%) -- guaranteed 4HKO
0 Atk Skarmory Iron Head vs. 0 HP / 0 Def Mew: 39-46 (22.2 - 26.2%) -- 9.4% chance to 4HKO
0 Atk Skarmory Brave Bird vs. 0 HP / 0 Def Mew: 58-69 (33.1 - 39.4%) -- 99.8% chance to 3HKO
So in short, when fully invested in Defense, it is only a tad less physically bulky than Skarm, while with the same spread it's spdef prowess blows the bird out of the water.
When fully spdef invested, the gap in physdef is more noticiable but the ability to take special hits is not even comparable between the two.
Regarding the offensive presence, I'll admit I expected a larger difference but it is still much less passive than metalbirb.
I expect it to be played more like a pivot in balance / bulky offense teams, as without recovery it's not expected to wall everything the entire game. Think Spdef Jirachi.
It can check a lot of new threats such as Tapu Lele, Tapu Bulu, Magearna, Kartana plus old ones like Landorus-I/T, Pinsir, Altaria, Clefable, Gardevoir, and the list goes on.
Definetely OU viable but maybe not OU by usage because of competition.