I have a 2013 Macbook Pro and an old Ipad. Both of which I want replace.
I currently use the MBP for editing (Lightroom) and hi-res printing (Canon Pixma Pro 100 S). Processing a few hundred images per year (Canon RAW). It also has primary storage for images as well as being the main house computer for docs, admin, banking, and the age as well as no further macOS system updates (security!) is the main reason for retiring it.
I could do like-for-like and get a new Macbook (not Pro) with M1 or M2 chip, plus a standard base model Ipad.
Similar price gets me a new Ipad Pro 12.9 inch 0.5 or 1tb storage. And add a mouse.
So the question really relates to the practicality of using an Ipad (vs MB). Especially importing RAW files and the LR software experience on both systems (IOS vs macOS).
I do wonder about printing on the Canon (are there even drivers for IOS), but this is not a major issue since I can use the old MBP for just printing.
Just a some of my experiences of doing the same thing here. I'm only an amateur/hobbyist, and my photos are not sold or distributed, only used for my personal needs and family.
So, as such, I went from an iMac (Late 2013) to an iPad Pro 12.9" two years ago. I was using Lightroom Classic and Lightroom (cloud version on the I-devices).
I didn't like Lightroom on the iPad, as it was missing too many key features (virtual copies, easy batch editing, external editor support, even red-eye). I also noted that the Adobe cloud system wasn't any more reliable than others services either, with some technical issues, they had been losing user's data.
I migrated everything over to Apple Photos, and I got the 2TB cloud storage (I now have the Apple One account). Of course it meant starting over with my organising and editing, but I persevered, and went ahead with that. Not something that's a great issue for me, I enjoyed re-editing the photos, and nothing has any great importance to remain as it was.
Like others, I also have a combination of extension editors - Raw Power, Pixelmator, Affinity Photo and a few others odds and ends (there are loads of apps you can use in a lite mode for free).
Most of these can access the Photos library directly, so your edits are visible as you apply them from any of the apps (beware of the Raw non-destructive workflow caveats though). With most you can either edit images in the Photos library from within the apps themselves, or with some you can choose to edit an image using the 'Share' button in Photos (there is a difference though).
Affinity is the anomaly here, it's a great editing app, but doesn't integrate well with Photos.
As for importing. I use a USB-C hub device I got off Amazon, that has a selection of connections (HDMI, SD Card, USB3 sockets, USB-C and a USB-C power socket). I import directly into Photos, and simply cull and organise in Photos - usually. You can also import into a folder on the iPad's local storage, and cull there before importing into Photos.
I have the 512GB storage option, and with the 2TB iCloud, and decent broadband, I don't really worry about using a little extra capacity for culling before I import. I've also been wary of doing anything directly with a media card, they can be a little fragile when it comes to that (or have been in my experience), I prefer to get everything onto a more stable storage before I do anything.
I do also sometimes import to my old iMac, where it's a little easier to import and cull. Organising is a little easier too, most things are a bit clearer on the larger screen, so I sometimes use it simply to make some tasks easier. I've decided it's not worth trying to sell the old iMac, so I'll keep using it for the odd jobs until it expires (it is working fine on Monterey using OpenCore Patcher).
I also use the iMac to save extra copies of the images to external drives as a proper archive and backup system.
It is all possible on the iPad, but some of it is just a bit easier if you have a larger screen, and normal desktop OS. I do all editing on the iPad though, it does have a much better screen for that, and is faster.