I have had a pet corn snake, also for my 8yo son (now 14) I'll give you my thoughts based on the experience...
Ds loved snakes and someone we knew locally had one to re-home as she had owned it for 8 years from a baby snake and now she was a young adult and was going travelling so needed a new home for the snake.
I was content that we would give it a good home and preferred the idea of that because a) not encouraging breeding for pet trade b) snake needed a home and we are good responsible carers c) corn snakes live to about 18 so figured as it was same age as son that would be good timing.
Snakes first owner played guitar and snake used to enjoy the vibrations, curling round her arm while she played, it enjoyed sunbathing in her lovely airy bedroom, was used to being handled and had had a good life for a captive non domesticated animal.
Snake came to live with us.
You can't give them live mice as mice sometimes try to defend themselves causing injuries (and horrible for the mouse obvs). So you buy mice frozen and the snake eats and poos once a week (the poo is nasty). The snake used to take his mouse in a rather bored fashion. Sometimes taking a while to bother eating it at all.
We took the view that the vivarium our snake lived in was hardly a stimulating environment though as large as we could fit and if we were a zoo we would be looking at what enrichment programme we could offer.
Where we live is rural so we took to giving the snake regular outings, where he moved through the field until he found the trace of a rodent, whereupon he would become alert and interested and would follow the scent to the burrow, at which point we would pick him up before he went down it (corn snakes aren't fast) and then we would give him his mouse. He then grabbed the mouse, threw his coils round it and swallowed it with gusto.
We were pleased we had enlivened his instincts and improved his quality of life.
He was taken outside regularly for several years and would even track rodents by swimming down our local stream! We never let him take wild food though, cos of risk of injury and infection.
Visitors loved the snake and children delighted in handling him (supervised), and he was fine with it himself (being used to it)... But he didn't actively want it - snakes are not social creatures, they don't need interaction and don't get much from it, apart from a change of scene.
Anyone not keen, didn't need to go near him as he was in a tank in son's bedroom.
The kids loved when he shed his skin and would take it to school (primary) where it's growth was measured and compared to the height of the children, biology lessons used it... Massive hit, even took the snake in once for show and tell.
Snake has since passed away, he died in the night after a few years and we don't know why.
My conclusion is that we'll never get a similar pet again, because novel and interesting as he was, fun to share with visitors, and we gave him the best life we could... There was no relationship there.
Snakes and spiders have zero need for social contact and so the deal is very one-sided.
His behaviour on his outings confirmed my strong sense that he would really really really prefer to be a wild snake...
Unlike pet cats etc where even if they had the option (if they have a nice home) they would choose to be a pet... That is not true of snakes and spiders.
We were basically holding this animal against its will... so though we had fun with it, and I'm glad he came to live with us, given the many other possible people who could have taken him on, there is no doubt that it is entirely selfishly motivated of humans to have pets like this.
Obviously if you care for them well then you are responsible and aren't abusing them as such, but I prefer my pets to be happy to be pets.
So we have a dog who loves us and chooses our company and chickens who are the same and aren't in any enclosure, roam the fields but choose to stay with us... And I think that is what an animal relationship should give - both parties what they want in life.
If you don't share my sensibilities of the animals pov and just want the fun of owning this interesting animal (a common wish, not judging you), I would encourage you to find a rehome as that way you are at least getting a creature whose demise will time well with child getting old and leaving home, and, you aren't encouraging breeding for the pet trade.
Hope that helps.