Hourly public transport isn't the end of the world provided it is reliable. What's more of an issue is that rural bus services tend to operate only from about 8am to 6pm at most. You need an 18 hour operating day (roughly 0600-midnight) to really be a car substitute. For instance I wouldn't commute to an office job by bus with a last bus around 1800, it needs to be much later for possible overtime and/or drinks after work.
Its certainly not just rural areas. The village I grew up in was around 5 miles from Wakefield and 8 miles (approx) from Leeds. We had 2x hourly buses to Leeds, operated by different companies with no ticket acceptance (unless you paid over £5 for the West Yorkshire bus rover). By the time I moved on (around 8 or so years ago), the quicker, worthwhile service essentially ran 8am - 6pm. Since then this service now doesn't operate to Leeds, leaving essentially no connectivity for a rapidly expanding (circa 400 houses built on just one houseing development of a few) village. It's insane.
But even back then, there just wasnt any draw to this service. The frequency wasn't enough to work with most people's lives (arriving up to 50 odd minutes early isn't tenable in 2024), the timetable spread, as you pointed out, doesn't give enough flexibility for after work drinks, meeting a friend for a meal, or even a meeting or call that goes on a bit too long.
When you have the option of just diving in the car, where you can get to the city centre some 20 minutes quicker, and pay a tad more for the convenience (when parking is taken into account), who wouldn't?
In terms of buses, Leeds seems to have done really well for the introduction of park and ride - using the bus for the last hop into the city. However, I think rail is always more attractive, as it gives the possibility of working on the move - something not possible on most buses. It tends to be quicker and take you right into town.