Have you ever sold a newer car for an older one?

My apologizes if this isn’t the correct subreddit for this question, but I’m in a bit of a dilemma and just want some advice. Long story short, I got a 2023 Mazda last year and paid it off in cash after trading in my car. I love the car but the seat is driving me nuts, it’s extremely uncomfortable and has been giving me back pain ever since and I gave it a good 5 months to see if my back would adjust and it hasn’t, so my only option is to ditch the car. My first thought was if I wanted to do this, it needs to be a car I know is comfortable to drive, I didn’t want to risk getting another car I won’t be comfortable in. My family currently owns 2 Honda CRVs, specifically 2016 year models and I love them, they’re very comfortable to drive, easy to work on (I do my own DIY repairs on cars) and last forever with minimal issues. I feel like I should just go that route as I know how the car will drive and feel and I feel like I’ll be more happier with that car, plus it’ll be paid off too with no payments.

I guess I’m just asking if it’s financially wise to go from a newer car, to a 10 year old car with higher miles (aiming for under 100K miles) I’ll make sure the CRV is in good condition, good carfax service history, etc but I know I could stretch it out another 10 years easily especially since I can do the repairs/maintenance myself and if I sold my Mazda, it would basically be an even trade so I wouldn’t be paying anymore money out of pocket and still walk away with a known reliable car and no car payments as I want to keep not having car payments, I could get another newer-ish car to trade in my Mazda towards but that would require me to finance the car which I don’t want to do.