Can I switch my automatic transmission for a manual one

You're really asking for trouble. Either stick the right one in or trade the car for what you want. You'll be missing sensors and solenoids so the Check Engine light will always be on. The Engine Computer will be different. You'll have to replace the brake pedal assembly and add the clutch pedal. The starter wiring will need to be changed since you won't have a neutral safety switch. You'll need a clutch switch instead. If you wire it direct so a clutch switch isn't needed, insurance investigators and lawyers love to find any kind of modification like that.

To see what other problems you'll be in for, visit the dealer's parts department and ask to see how many parts are listed as "with automatic" and "with manual". Engine cross members can be different. Coil springs need to be stiffer for the added weight of an automatic. And those are just the things I can think of quickly. I've seen people try to do these types of modifications and they rarely turn out successful. There comes a time when someone has to change your mind to avoid lots of cost, time, and frustration. Honda doesn't have much transmission trouble so if you're just trying to find the cheapest alternative, find an automatic from the same year and model in a salvage yard.

Going from a manual to an automatic is a lot easier. I won't argue your concern about an expected failure, but I haven't heard of that issue with Hondas. If you're going to attempt this difficult modification, be sure you have two or three manual transmission donor cars located in the salvage yards. Try to find cars from the same model year. Engine Computers and wiring harnesses usually change every year, and sometimes more often. The closer you can stay to your model and year, the better chance you'll find the needed parts.