
Sounds like you are having a storage problem.
Dedicated cameras are better for quality pictures but they are very clunky to carry around. It doesn’t solve your storage problem and it seems you are not looking to solve a picture quality problem.
The easiest solution tech-wise would be google photos. Set it up to automatically upload and delete the version on your phone. You can share uploaded pictures directly to social media or people. Youtube is also in Google’s ecosystem so AFAIK you can prompt the AI in Google photos and create videos for Youtube. Note that if you take a lot of pictures you must pay to have expanded storage to support the above.
A similar self-host option would be immich.

In my opinion the “store everything” approach is actually a good thing. By not caring about which pictures look best I can immerse myself in the moment more instead of caring about storage. Many times when I reviewed pictures I took in the past, shots I thought were terrible actually captured details that the “good” shots didn’t. You’ll have more clarity when leisurely reviewing pictures on a computer.
I agree that storing pictures on someone else’s service is not a good idea in the long run. The recent AI hype wave affected RAM, SSD and HDD prices. I think grabbing large SD cards now before they are affected too would be a good move.