A lot of things were different in the 1960s, not universally for the better and most of which is not coming back.
"it's worth remembering that back then almost everyone created open-source software code to help other users get things working. And everyone could read the source and update their own work without having to panic about what might happen."
That's a bit charitable. Since people were writing in assembly quite frequently, the programs people received could be more easily edited. You can theoretically modify the binaries we receive today, but it's harder because they're compiled from more complex languages and tend to be much bigger. A lot of software wasn't open source just in the sense that it wasn't published for anyone's use, but kept restricted to the organization that wrote it or to people who bought it. Those people would have access to the code, but it wasn't like modern open source is where any person who wants can get a copy for free in a few minutes and with clearly defined rights to copy, modify, and distribute.
"CP/M and MSDOS were created and while they made a few people get a decent payroll, neither operating system generated millions"
Millions of what? Of dollars or pounds, yes they did. Digital Research had revenue of $45M in 1983. We all know how profitable Microsoft was. Some of that came from other software like compilers for DR or productivity software from MS, but a lot of that relied on the operating systems that software ran on. Millions of computers? I'm not sure, but I think DOS did have millions of installs eventually. CP/M came along too early to get mass adoption because computers weren't mainstream in the 1974-1983 period.
"But now Twitter is worth 41 billion dollars"
No, somebody paid $44B for it. That doesn't mean it was worth that much, and now that that person has spent a few months smashing it, it's worth less than it used to be.
"where did all that money come from,"
From the people who thought that Musk-owned companies are a lot better than anyone else making similar products and thus valued them very highly, from cryptocurrency speculation, and banks who are now regretting that they put up cash when a billionaire decided to make an impulse buy. But if you're meaning companies other than Twitter, such as modern operating systems, it came from the fact that billions of people are using computers today who had never thought of doing so in the 1980s.
"and where is it going? Is everyone happy or just in debt?"
Everyone isn't happy, but I'm not sure that's ever an option. If we're specifically speaking of Twitter, then some people don't use it (myself included), so my happiness level hasn't changed as it's been damaged. If we're talking large corporations in general, we had large corporations before; they were just different names. It causes problems now for the same reason that it did before, and we'll have to deal with that, but it's not always on the top of my list of problems I need to solve.