The Hornet 2P dimensions are 43/31W at the head/foot x 87L.
Compare that to say, the Big Agnes Copper Spur UL2 at 52/42W x 88L, the BA Tiger Wall at 52/42W x 86L, or the Nemo MayFly at 52/43Wx85L.  I would say the BA Copper Spur and TW 2’s are the most popular name brand free standing tents on the market in the LW category. Maybe one of the MSR tents is in there too.
Some would argue that if you can’t fit two 25″ rectangular pads in a tent, it’s not a “true” 2P tent, and thus ALL of the above would fail that test. *shrug*Â That’s not my characterization, but some of the popular Youtube content creators have said that, although I can’t specifically tell you which one(s) I’ve seen make that claim.
Also, judging by the photos of the Hornet 2P and it’s teeny tiny 3rd cross-bar, there is a significantly less shoulder room when sitting up in the Hornet compared to any of the other aforementioned tents.
My TarpTent Stratospire 2 is 52Wx86L. Sharing a Hornet 2P with another person would feel very cramped indeed compared to my SS2. Our very first backpacking tent was the 2007 REI QuarterDome UL2. It had floor dimensions of 52×85 but it had a simple 2-crossed poles design, so the shoulder room while sitting up wasn’t that great. A bit off-topic, but I think introducing a 3rd crossing pole to tent designs in the last 15 years or so for self-standing tents have really made them feel more roomy. Only REI’s cheapest 2P tent (the TrailMade 2) still uses the simpler 2-crossed poles design from 17 years ago.