Short answer: No.
Apple TV (ATV) is a media streaming box. When the 1st generation ATV launched 9(!) years ago it was pretty revolutionary. Up to that point the industry had been pushing the Windows-based Home Media PC as a solution. The problems with that were cost, size, noise, heat and a lack of much in the way of content to stream. Suddenly Apple made a relatively small box with an internal hard drive that did a lot of what a Home Media PC did but without all the Windows hassle and at a fraction of the price. What's more, they made a library of stuff accessible via the iTunes store. Okay, a lot of the content was US-centric, but at least Apple had thought about content as much as hardware.
ATV2 launched in 2010. Much slicker and smaller but now minus the hard drive. These are what you might often see jail broken on Ebay. Apple's philosophy has always been to have a closed system where they control the hardware and what software and streaming services can be run. Jail breaking an ATV2 took that control away from Apple so that 3rd party applications could be run on the ATV2 box. One of the most significant applications was X-Box Media Centre (XMBC for short). As the name suggest, this started out as a 3rd party application to run on X-box consoles but has since developed in to much more than that. XBMC is now renamed as
Kodi and it is a software front-end that provides the means to watch and listen to streamed content from the web and from one's own storage either on a local hard drive or a network storage device (NAS or networked PC).
When ATV3 launched in 2012 they closed the jail break vulnerability on products going forward. Since then (AFAIK) ATV 3 & 4 boxes can't be jail broken. However, that's no longer an issue because of what has happened in the rest of the market.
Between 2010 and 2012 we started to see competitor products becoming available.
Western Digital TV (WDTV) and
Roku were two of the most well known. These could access streaming services outside of Apple's eco-system. We also started to see the first Android TV boxes. These were based on the same operating system as Android smart-phones and, crucially, had the ability to run 3rd party apps as a standard feature.... Hello
Kodi! The latest Android boxes are available fully loaded with Kodi and other streaming access apps with prices starting around £25.
Android isn't the only game in town though. Google Chromecast, Amazon Fire TV (a box), Amazon Fire TV stick (a HDMI dongle), Now TV, Raspberry Pi, smart TVs and Blu-ray players and home cinema systems, Freeview Play recorders..... the list goes on and on and all these can access various online streaming services and catch-up TV.
A jail broken ATV2 used to be the daddy of media players because it was small, relatively cheap and it worked well; but that was 8~9 years ago. Today it looks antiquated (no 1080p, no 3D support, no HD audio), expensive, and if you want any official Apple firmware updates then you have to reset the box i.e. remove the jail break and then re-apply it after which is a P.I.T.A. If I wanted access to Apple's services then I'd buy a later ATV3 (new/used) for around £40-£60 and then tip £30~£70 in to one of the other devices listed above. I realise that for some people the idea of having two boxes fries their brain; "Why can't I do it all with one box?" to which the answer is that Apple is a closed system. If you want their latest services then you need their later hardware devices, but if you want everything else as well then they can't help you. It has to be a second box for Kodi and all the other streaming services available.
Regarding Sky and Freeview...
Sky and Freeview are for the most part what we call
linear TV. That is to say it follows a schedule so you either watch live or record a programme for consumption at a more convenient time. Both platforms now support some limited catch-up services. As long as you have the appropriate version of a Sky HD box and an internet connection you can download some programmes via their catch up service. It's a similar story if you have a
Freeview Play PVR. Both platforms do limit your choices to what's in their core schedule though. For example you couldn't stream a dodgy version of the latest cinema release (not that you'd want to do that of course for legal reasons
) or say play a movie that you have stored on your home's own media storage system. Sky sees Netflix and Amazon Prime Video as competitor services. Both offer a library of films and TV box sets for streaming rental. Sky offers something similar from its own libraries via Catch Up TV and Sky Box Sets and Sky Cinema and Sky Store.
Before spending any money on hardware I think you might want to start from a point of view of "What do I want to watch?". You may find that your needs are already catered for via Sky, or that all you need is something simple such as a Google Chromecast or Amazon Fire TV Stick.