More than half of the UK public feels excited about the potential implementation of artificial intelligence (AI) in the National Health Service as part of a nationwide study.