I'd be amazed if they gave you prison for that. However, if/when you are banned, you will also get a licence endorsement, which means that your conviction won't be spent for five years. So, it will be shown on any basic DBS checks done in that time. Once it's spent, it's no longer relevant for insurance, so you can either insist your insurer disregards it, as they have a legal duty to do, or other insurers are available.
As the offence can be filtered, it would be removed from a standard or enhanced DBS check 11 years after the date of conviction.
Robert Lightfoot, former head of NASA, said it succinctly in his parting speech in April 2018: Protecting against risk and being safe are not the same thing ... [W]e must move from risk management to risk leadership. From a risk management perspective, the safest place to be is on the ground. From a risk leadership perspective, I believe thats the worst place [we] can be.