It's a pretty old style, if I remember correctly it came out of the British Isles during their sorry of post-1776 apple boom.
Basically the USA had developed types of apples that could keep well enough to ship overseas and the British public absolutely loved them, to the point that it was threatening the native varieties. So a campaign was formed to grow new varieties to complete, and the Cox's Orange Pippin was one such effort.
"Pippin" is this case, means that it was grown from seed, not a graft, which makes sense because it was a brand new variety but that's beside the point.
Taste wise, it shares a lot of flavor notes as the Honeycrisp, as well as that big crunch, but it's a bit less sweet and more complex, with other flavors coming in. It even looks a lot like a Honeycrisp but the colors are more muted and muddy
As for competition, here in New England it's only grown by boutique orchards, so it's very hard to find, but not threatened. And just to be safe, I'm growing my own on a tree in the backyard.
So yeah! Absolutely recommend trying to find an online seller if you aren't fortunate to live near an orchard
