I had the same problem with my old Handicam. I could record almost an hour on the SD card, but that’s it. And the video quality wasn’t the greatest. When I went to upgrade the card, I was told mine was so old that I couldn’t even buy a compatible storage upgrade. I use my phone now and it works great with the storage upgrade I bought with it. I can record for a few hours straight in HD and my new phone even records in 4K. Editing and posting the vids is super easy too...couple of apps on the phone let me edit and post to YouTube. Nothing too fancy, but great for what I do with it.
I used to use my phone also but I had a really old phone and it didn’t have much memory so I kept running out of storage on it. Then I found the Sony at a really good deal and bought it just to record pool on. Hadn’t had a problem until the last few times I have tried it. Today I formatted the card so we will see how that goes. I got a newer phone since then but still not the best out there by any stretch of imagination. I’ll try again sometime as I’m not playing much right now but I want to get back to practicing more in the next couple weeks.