1) seek counselling, because the scope of your problem exceeds that which free advice from unknowns can help with. I did, and it helped me to re-frame what I wanted from the world, from work. It costs money? It's money well spent.
2) if you are not highly goal oriented, ask yourself if you are highly money oriented because if you can reduce your basis of costs, you can reduce the work hours, and maximise the non-work hours. If you do like money and things and expensive lifestyle, you have to either turn to a life of crime, or continue to work.
3) the corollary of 2) is "be careful what you wish for" because without 1) you risk falling into a slough of despond, because it turns out not working is very bad for people's mental health. It's the underpinning of relevance deprivation syndrome, of FOMO, of isolation.
4) but 3) said, there are so many ways to stay engaged in a community of like minds. Volunteering, pursuing sport and social activities, but I encourage you to think about badly paid, physical labour, with others, outdoors, because that turns out to be healthy too. Nobody is paying google 10x norm for manual labour, but some manual work is satisfying work. Go clean dishes at a childcare centre. Pack shelves. Free your inner OCD and sort books at a library. Learn how to chainsaw.
5) you're a long time dead. you're unlikely to be a fossil of interest to any future archeologist, purely because of statistics. Given you don't have long in geological time here, it's worth getting the most fun out of it. If work doesn't cut it for you, then find the sweetspot of income and work which does, and seek help to get there. 1) is gold. Be prepared to spend money to be advised how to re-frame your sense of self.
If your answer is "I can't afford to do that" then you have an immediate answer to the problem of not liking work.
I knew I hated work within 1 month of graduating in 1982. But it turns out, Jack Black was right and "sticking it to the man" by doing amazingly well at not working at work, while still getting things done, is actually, kind of OK. The key thing is getting things done. If you can't get things done, nobody wants to pay you. If you can get things done, nobody much cares if you don't think of it, as work.
(still learning what I want to be when I grow up, retiring inside 4 years before I'm 65, gainfully employed, renumerated adequately to my needs)