I've just come across this blog which amongst other things details the history of the 41 route that operated around the Hampshire and Surrey border until the end of last month (March) when it was withdrawn by Stagecoach.
It's quite a lengthy read and may not be of great interest to Coffee Shoppers, but the scans of the timetables over the years at the end tell the story well.
https://handsbusblog.wordpress.com/2023/02/06/bus-stops-appear-route-to-disappear/Ultimately whether it's a bus or a train service, I think the starting point of "this must make a profit" is not really compatible with the service that is public transport.