Rail across the US doesn't not make sense. Even North South the US is too big for rail to make sense. However there are a lot of shorter trips that would make sense via rail if the network existed and had competent operations. That Amtrak only makes money on the Boston-DC routes (or so they claim) more about their bad management and decades of bad decisions to not invest in making anything else worth using.
For example, the Cleveland and Pittsburgh metro areas are over 2 million and just over 3 hours apart by train or car. However, there is currently only one train from Cleveland to Pittsburgh a day, and it leaves at 1:54 AM. Obviously, most people will drive if that's the only alternative, but that does not say much about the general viability of inter-urban rail between those two cities.
There are good discussions about Amtrak routes and the most recently-planned Amtrak expansions here: 1. https://humantransit.org/2023/07/amtraks-endless-ridership-c... 2. https://humantransit.org/2023/08/amtraks-long-distance-train...
It’s possible that other viable routes exist, but unfortunately the political environment makes some of them impossible to build. For example, a French railroad operator working on the California high speed rail project bailed out in 2011 due to “political dysfunction”, instead building a high speed rail line in Morocco that finished in seven years. So in some theoretical alternate universe where California was as politically functional as Morocco, maybe they could have a modern bullet train between LA and SF. I’m not holding my breath for that to happen though.
Personally I’m happy to leave the question to private investors. I wouldn’t put any money in your proposed Cleveland-Pittsburgh line but maybe you can prove me wrong. I am also dubious that Texas would be a good candidate for passenger rail; Texas has very good highway coverage and the way Texas cities are laid out, you’d need to rent a car on either end of your train journey anyway so it really makes more sense to drive.