Assuming you’re not looking to learn high-level classical and jazz piano, I don’t think you need to worry about finding a teacher or obsessing about piano pedagogy like they do in the piano forums I frequent.

If you’re just looking for a decent foundation in rock / pop / blues / country keys, you can do well learning from a few books and then looking up YT videos that will help you answer and specific questions you have.
The problem is that even simple-sounding keys can be much trickier than you think they’re going to be, especially when hand-independence is an issue. It can take a bit longer to get up to speed compared to bass or guitar. I myself was playing bass in bands with less than a year of practice, and I started teaching a friend guitar in January of ’24 and he was ready for us to play some garage parties by the end of the summer. Keys might take a bit longer, so be prepared to hunker down for a bit.
As a starting point, I recommend Mel Bay’s Modern Piano Method (volume 1 – the only volume they’ve put out so far) by Per Danielsson. Like the Modern Guitar Method series, it’s meant to provide the non-classical equivalent of a systematic and musical method. You’ll be able to see that it focuses on the sorts of things you’d likely play in modern (non-classical) genres. It’s not always super musical, but if you really put in the work, you can probably get through it in a reasonable time frame, and then you’ll have the foundations of technique for more musical things.
After (or along with) that, you might look at the Complete Rock Keyboard Method by Joe Bouchard, et al. I think it's a great next step after Mel Bay, covering some similar things and building from them, and in a much more musical way, with real songs and everything. Though it says “rock” it’s pretty generalizable to other related genres.
I can also recommend a couple of great YT channels:
pianoTV TONS of instructional material here. It’s geared toward classical, but there are great videos for complete beginners about how to sit at the piano, posture, hand position, etc.
Christian Fuchs As the title suggests, it’s mainly for blues, but that’s the foundation of a lot of rock and pop music anyway. He also has some other genres in there such as rock and country. He’s also a hoot, very amusing to listen to.
One last thing. Organ playing has some technical peculiarities not always addressed in modern keyboard methods. Unfortunately, there aren’t a ton of great books about it, but there are some good YT videos. If you get into that, just search around and you’ll find stuff.
Hope that helps!