I remember sitting in a senior seminar class in 1989 full of CS students. We were solemnly informed by a very earnest IBM employee that we would regret having majored in computer science because IBM's CASE tools were going to kill job market. That aged like milk.
Will something come along some day that will actually drastically reduce the need for programmers/developers/software engineers? Maybe. Are we there yet? My LLM experience makes me seriously doubt it.
I lost my "Clear Creek Bike Book" in the 1980's but eventually Sheldon made me not miss it at all.
It's not as comprehensive, and more corporate than Sheldon's site, but I currently love Park Tool's youtube channel (https://www.youtube.com/@parktool). They shamelessly mention their tools, but they frequently give alternatives like, you can get this park tool for pushing your disc brake pads back into place, or you can just use a plastic tire tool.