I don't live in the UK, but the BBC is always a good source, compared to Wikipedia anyway:
"National assistance funerals, as they are known, are carried out by local authorities for people who die alone or with relatives who are not able to pay."
https://www.bbc.com/news/uk-scotland-37999757
https://en.wikipedia.org/wiki/Pauper%27s_funeral
Subsidizing the cost would be one thing—modern funeral expenses, at least in America, can get truly bananas—but taking over the arrangements themselves might deprive the dead's loved ones of a chance to hold specific religious rites, serve a meal with personal significance, choose a meaningful engraving for the headstone (and find a particular plot of land for them to come visit it later), and so on.
Rather than a burden on your loved ones, think of it as a chance for them all to say goodbye and share how much they're going to miss you!
But i m sure if nobody is interested in the body, a standard burial does take place.