I know these things from experience, having lower back pain on and off for 30 years. Yeah, I'm "old" now, and other parts get involved, like knees and hips. But I've learned that a bad back can cause changes in posture, gait, etc. That is, the tendency is to compensate for the movement limitations imposed by the back problem which eventually puts pressure on other joints. IOW a back problem can have negative downstream effects, so get the consults you need.
The article confirms the importance of the right exercise preventing and managing back pain. The worst thing is prolonged "rest", continuing normal activity is the key. I'd also advocate my "no bending or twisting" rule, and taking care when attempting to move heavy items. Mainly a matter of self-observation, but that's a whole program in itself.
The trouble with bro science is that those lifters may never have actually had the problem you're experiencing, and if they had, may not have had it in the same way that you have.
Core strengthening exercises are good in general as stronger/thicker muscle better protects the connective tissue providing backup support for your joints. It's a reason some athletes can tear ACLs and such and walk around normally while a normal person might end up debilitated.
Please get a referral from a sports medicine specialist for a physio. Even if you go only once, have someone give you strategies for strengthening and protecting your back the safe way.
In addition, running and sit ups can also help massively. But don't over do it until you're completely mended.
The truth is simple but boring: https://news.ycombinator.com/item?id=10640658
Ever since then, I haven't quite recovered. My back feels fine most of the time, but every few days it aches quite a bit. I recently tried to start working out again and the pain flared up immediately. I've spoken to a few serious weight lifters, and they've told me that reverse hyper machines can help rehabilitate mild lumbar disc herniations (which is what I have). I can't tell if this is "bro-science" though or something that actually works; a quick search on Google Scholar reveals nothing. Also, most gyms do not have reverse hyper machines, so I would have to drive out of my way to use one, or purchase one. Does anyone have any experience with these machines?