CR-V competes against Toyota RAV4, Maxda CX-5, Ford Escape, Nissan Rogue, Jeep Cherokee, Subaru Outback, etc. Technically it's called a compact SUV (or compact crossover), and it has now become the largest and fastest-growing vehicle segment, and the CR-V is the top seller in that segment. By some metrics it is now actually the top selling vehicle in America.
Resale value is not laughable, because with Hondas it means you can sell a 15-year old car for a decent chunk of change. Just try listing a Honda Accord for sale vs. a similar car from another brand and see what you get more calls about. It also means higher trade-in values because dealers jack up the prices on used Hondas. When I was in college, I bought a used CR-V for $4600 that needed a few things fixed. I put about $1000 total into it, drove it for 3 years, and sold it for $6000 to buy my Acura.
By sporty manners, I'm talking about tighter steering and suspension, shorter-throw gearboxes, engines that are designed to be revved really high, etc. I'm not talking about RWD muscle car sportiness or giant HP/lb-ft figures. Try driving a V6 Accord Coupe, or a Prelude, or a Civic Si, or an S2000.